Empty blocks in a table
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
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
0