Blog: Carlos Sierra |
|
213 blogs
updated: 74 min. ago
|
||
|
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 ...
|
||
|
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...
|
||