Advanced Methods for Managing Statistics of Volatile Tables in Oracle (Hotsos 2012)

Thanks to all who attended my presentation at Hotsos 2012. You were a great audience with insightful questions and relevant comments.

Here is my presentation  along with the white paper.

The code for JUST_STATS package (spec and body) is available for free. Note that I cannot support the package and I do not accept any legal liability or responsibility for the content or the accuracy of the information so provided, or, for any loss or damage caused arising directly or indirectly in connection with reliance on the use of such information.

The readme and the file with examples could quite useful as well.

Hotsos is such a great conference… I had to fly back home on Tuesday morning, but I wish I could stay longer.

 

August 2014:

P.S

There is a patch for JUST_STATS package – http://wp.me/p1DHW2-9L . It allows it to work with partitions.

4 Responses to Advanced Methods for Managing Statistics of Volatile Tables in Oracle (Hotsos 2012)

  1. Hi Lordan, that was a good article. We are facing the same volatility issues with our loading and reporting. However when testing the package, it does not deal correctly with partition. when you specify
    partname=> and granularity=> it still proceeed to gather the stats for the entire table and not just for the partition. Is there an easy fix for this?

  2. Quabs says:

    Hi Lordan, thanks for sharing. The just_stats does not seem to deal with partitions. When I pass it the name of the partition and specify the granularity, it still gathers stats on ALL partitions. Is there an easy fix for this?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: