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...
|
||
|
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...
|
||
|
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...
|
||
|
Introduction This post is about: "Adapting and adopting SQL Plan Management (SPM) to achieve execution plan stability for sub-second queries...
|
||
|
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...
|
||
|
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...
|
||
|
First things first: Do not rebuild Oracle indexes! Unless you have to. If you are even considering rebuilding indexes on an autonomous manne...
|
||
|
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...
|
||
|
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...
|
||
|
Using the default Maintenance Window for automatic tasks such as statistics gathering and space advisor is just fine except when the number ...
|
||