Blog: Carlos Sierra |
|
208 blogs
updated: 75 min. ago
|
||
|
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...
|
||
|
Working on the new eDB360 repository I came across this "ORA-00997: illegal use of LONG datatype" while trying to CTAS on the following DBA ...
|
||
|
As many of you know, eDB360 is a free tool that provides a 360-degree view of an Oracle database without any installation. A new version is ...
|
||
|
eDB360 has always worked under the premise "no installation required", and still is the case today it is part of its fundamental essence: gi...
|
||