Restoring Optimizer Statistics

Posted by Gavin Soorma
On March 29, 2011
0 Comments

In some cases we may find that gathering fresh statistics has led to the optimizer executing sub-optimal execution plans and we would like to restore the statistics as of a date when we had good performance. REMEMBER – we gather statistics to ensure that the optimizer chooses the optimal execution plans, but gathering statistics invalidates […]

Posted by Gavin Soorma
On March 25, 2011
0 Comments

You need to be logged in to see this part of the content. Please Login to access.

Posted by Gavin Soorma
On March 14, 2011
4 Comments

You need to be logged in to see this part of the content. Please Login to access.

Posted by Gavin Soorma
On March 11, 2011
0 Comments

In one of my earlier posts, I had discussed the process of setting up a 11g Standby Database using the DUPLICATE FROM ACTIVE method where we do not use any RMAN backup to create the standby database, but copy the datafiles from an active running database over the network. Let us now have a look […]

News

Restoring Optimizer Statistics

Using GoldenGate Tokens with the COLMAP clause

GoldenGate performance tuning using the RANGE function

Creating a 11g Data Guard Physical Standby Database using Enterprise Manager Grid Control 10.2.0.5