Dear Experts,
I want to know how "DBMS_SPACE.UNUSED_SPACE" work.
Then, I have two questions about this procedure.
1. Does the procedure gather information from CBO? or freelist of index ? or datablocks of index?
2. During the execution ,does the procedure lock the index for DML ?
Our system is SAP R/3 Enterprise 6.4.0 and Oracle 9.2.0.6.0.
Many Thanks,
Koji Kurosawa
Edited by: Kouji Kurosawa on Nov 26, 2009 11:41 AM