DBA Data[Home] [Help]

APPS.FND_STATS dependencies on DBMS_SPACE

Line 58: DBMS_SPACE.UNUSED_SPACE(upper(schemaname),upper(object_name),upper(object_type),total_blocks, total_bytes,unused_blocks,unused_bytes,last_extf,last_extb, last_usedblock);

54: last_extf NUMBER;
55: last_extb NUMBER;
56: last_usedblock NUMBER;
57: BEGIN
58: DBMS_SPACE.UNUSED_SPACE(upper(schemaname),upper(object_name),upper(object_type),total_blocks, total_bytes,unused_blocks,unused_bytes,last_extf,last_extb, last_usedblock);
59: RETURN total_blocks-unused_blocks;
60: EXCEPTION
61: WHEN OTHERS THEN
62: -- For partitioned tables, we will get an exception as it unused space