Blog: Carlos Sierra

224 blogs updated: 80 min. ago
Doing a SQL Plan Baseline fleet cleanup, I wanted to get the SQL_ID give a SQL Plan Baseline. Long ago I wrote a PL/SQL function that inputs...
17-01-2019 02:09:27 Carlos Sierra Oracle
Scripts to deal with SQL Plan Baselines, SQL Profiles and SQL Patches
To mitigate SQL performance issues, I do make use of SQL Plan Baselines, SQL Profiles and SQL Patches, on a daily basis. Our environments ar...
15-12-2018 15:03:03 Carlos Sierra Oracle
Introducing SQLdb360: merging eDB360 and SQLd360, while rising the bar to community engagement
Today, we are very happy to release SQLdb360, a new tool that merges together eDB360 and SQLd360, under a single package. Tools eDB360 and S...
11-06-2018 17:03:31 Carlos Sierra Oracle
Adapting and adopting SQL Plan Management (SPM)
Introduction This post is about: "Adapting and adopting SQL Plan Management (SPM) to achieve execution plan stability for sub-second queries...
21-12-2017 03:41:47 Carlos Sierra Oracle
Creating a SQL Plan Baseline from Cursor Cache or AWR
A DBA deals with performance issues often, and having a SQL suddenly performing poorly is common. What do we do? We proceed to "pin" an exec...
01-12-2017 16:08:02 Carlos Sierra Oracle
Purging a cursor in Oracle – revisited
A few years ago I created a post about "how to flush a cursor out the shared pool", using DBMS_SHARED_POOL.PU RGE. For the most part, this m...
22-11-2017 15:08:30 Carlos Sierra Oracle
Autonomous Online Index Rebuild for Oracle Multitenant
First things first: Do not rebuild Oracle indexes! Unless you have to. If you are even considering rebuilding indexes on an autonomous manne...
08-10-2017 02:55:30 Carlos Sierra Oracle
Poor's man script to summarize reasons WHY cursors are not shared
Having a large number of child cursors can affect parsing performance as hinted by Abel Macias on his blog post about Diagnosis of a High Ve...
01-09-2017 22:24:11 Carlos Sierra Oracle
Script to identify index rebuild candidates on 12c
Some time back I blogged about an easy way to estimate the size of an index. It turns out there is an API that also uses the plan_table unde...
12-07-2017 20:38:24 Carlos Sierra Oracle
One Maintenance Window for all PDBs… Really?
Using the default Maintenance Window for automatic tasks such as statistics gathering and space advisor is just fine except when the number ...
06-07-2017 03:40:06 Carlos Sierra Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.