OraFAQ Forum: Server Administration » What is the difference?

Home » RDBMS Server » Server Administration » What is the difference?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 10:24:32 CST 2025