Blog: Carlos Sierra


210 blogs updated: 37 min. ago
Introducing SQLdb360: merging eDB360 and SQLd360, while rising the bar to community engagement
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...
0
11-06-2018 17:03:31 Carlos Sierra Oracle
Adapting and adopting SQL Plan Management (SPM)
Introduction This post is about: "Adapting and adopting SQL Plan Management (SPM) to achieve execution plan stability for sub-second queries...
25
21-12-2017 03:41:47 Carlos Sierra Oracle
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...
36
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...
37
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...
40
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...
37
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...
41
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


© 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.