jump to navigation

is it possible to copy the stats? – YES >> DBMS_STATS >> COPY_TABLE_STATS May 8, 2010

Posted by sendtoshailesh in Uncategorized.
trackback

While working in data integration project, I got the opportunity to tackle very large 2-Level partition tables. Here we have to add partition or I could say at granular level, sub-partition on every week-end. Moderately these partitions and subpartions get loaded with heaps of structured data.

Ah…at this stage we need to take care of table statistics. Most diffcult part is when, which can suit to user’s query. Its been very long time I felt need why we can’t copy the stats which is already genearted for some partitions to another partition?

Now the answer is YES.

DBMS_STATS.COPY_TABLE_STATS………..with this new feature in 11g it is possible.

I was going through several tech article but at below link one can find the best usability of this.

http://oracledoug.com/serendipity/index.php?/archives/1596-Statistics-on-Partitioned-Tables-Part-6a-COPY_TABLE_STATS.html

This is best explained with in-lined examples

enjoy!!

About these ads

Comments»

No comments yet — be the first.

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.

Join 83 other followers

%d bloggers like this: