Exadata General (MOSC)

MOSC Banner

HCC partition--search for # of rows or % of partition that has been uncompressed

edited Mar 11, 2013 11:46AM in Exadata General (MOSC) 2 commentsAnswered
 Hello-We have have just implemented HCC, at the partition level on a few tables.  Since the users have indicated they only update/insert into the most current partitions and rarely on the older partitions, I'd like to monitor the HCC partitions to see if any data is updated, thus uncompressing those rows.
These updates occur via a batch job and is not a direct path load so I know they won't be compressed.  I do not want to look row by row but rather get a percentage or row count that was uncompressed within each partition.  Is there a way or some script to do this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center