Blog: Carlos Sierra


209 blogs updated: 13 min. ago
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...
33
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...
32
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...
39
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...
34
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...
38
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 ...
30
06-07-2017 03:40:06 Carlos Sierra Oracle
How to execute some SQL in all Pluggable Databases (PDBs)
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...
33
04-07-2017 01:41:57 Carlos Sierra Oracle
eAdam 3.0
Source: eAdam 3.0
23
17-04-2017 04:47:54 Carlos Sierra Oracle
eDB360 meets eAdam 3.0 – when two heads are better than one!
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...
27
10-04-2017 23:42:20 Carlos Sierra Oracle
"ORA-00997: illegal use of LONG datatype" on a CTAS querying a view with a LONG column
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 ...
28
03-04-2017 22:04:27 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.