Blog: Carlos Sierra |
|
210 blogs
updated: 11 min. ago
|
||
|
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 ...
|
||
|
If you are on 12c (and you should) and your database is truly multitenant, you may be in need to execute some SQL in all PDBs. OEM is awesom...
|
||
|
|
||
|
Version v1711 of eDB360 invites eAdam 3.0 to the party. What does it mean? We recently learned that eDB360 v1706 introduced the eDB360 repos...
|
||