Database Administration (MOSC)

MOSC Banner

Empty blocks in a table

edited Apr 23, 2010 4:10AM in Database Administration (MOSC) 8 commentsAnswered
 Hi we are using 10g R2
Assuming that we created a table and populate it with data and ended up having a table with 100 blocks (all 100 blocks have data)
we ran the query against user_tables and it showed num_blocks as 100 and empty_blocks as 0 ZERO
Now we deleted half of the data and lets assume that that data spanned 40 blocks

Now, if we query the user_tables again would we see the empty_blocks to be 40?


We are trying to automate the process by weekly scheduling a job that reports on the schema tables which is fragmented, i.e. it has EMPTY BLOCKS as a result of DELETES operations? What is the best way to accomplish this? We are not using Standard Edition of 10g R2

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