DBMSSPACE.SPACEUSAGE - Definition - Oracle Schema

Q.  Using PL/SQL Packages to Display Information About Schema Object Space Usage which Returns information about free data blocks in an object (table, index, or cluster) whose segment space management is AUTO?
- Published on 19 Oct 15

a. DBMS_SPACE.FREE_BLOCKS
b. DBMS_SPACE.UNUSED_SPACE
c. DBMS_SPACE.SPACE_USAGE
d. None of the above

ANSWER: DBMS_SPACE.SPACE_USAGE

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - Oracle Database provides data dictionary views and PL/SQL packages that allow you to display information about the space usage of schema objects.

    - Views and packages that are unique to a particular schema object.

    - It describes views and packages that are generic in nature and apply to multiple schema objects.

    - These Oracle-supplied PL/SQL packages provide information about schema objects:

    - DBMS_SPACE.UNUSED_SPACE - Returns information about unused space in an object (table, index, or cluster).

    - DBMS_SPACE.FREE_BLOCKS - Returns information about free data blocks in an object (table, index, or cluster) whose segment free space is managed by free lists (segment space management is MANUAL).

    - DBMS_SPACE.SPACE_USAGE - Returns information about free data blocks in an object (table, index, or cluster) whose segment space management is AUTO.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲