Skip to Content
0
Former Member
Nov 26, 2009 at 10:41 AM

how "DBMS_SPACE.UNUSED_SPACE" work

148 Views

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