Home » RDBMS Server » Server Administration » What is the difference?
What is the difference? [message #57865] Fri, 11 July 2003 13:34
Jadie
Messages: 64
Registered: January 2002
Member
I am reading Oracle document about these two packages.

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.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Please look at the sentence I highlighted. Can you tell me the difference? Thanks a lot

Jadie
Previous Topic: Enterprise Edition or client ?
Next Topic: ver good questions, need help
Goto Forum:
  


Current Time: Fri Sep 20 07:20:34 CDT 2024