Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue in understanding the negative Wasted space value for a table while fragmentation

1016967Jun 18 2013 — edited Jun 20 2013

Hi All,

After running the command for getting Fragmentation on tables, i am getting a negative wasted_space for my table. However for rest of the tables i am getting positive value. Can anybody help me to understand that.

OWNER TABLE_NAME size (kb) actual_data (kb) wasted_space (kb)

------------------------------ ------------------------------ ---------- ---------------- -----------------

PROVPROD BATCH_REQUEST_RESPONSE 4736696 4840637,48 -103941,48

Regards,

Arun Singh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2013

Added on Jun 18 2013

#general-database-discussions

15 comments

5,582 views