Re: Question about Package DBMS_SPACE

James,

DBMS_SPACE does neither a compute nor Analyze - it goes off the block header or freelists details depending on the procedures you're using within the package.

Scott Hutchinson.

James Hull wrote:

> Hi there:
>
> Does anyone know what does this package do in order to return the space
> usage results? I looked at the Oracle Documentation, it only mentioned that
> the user needs ANALYZE privilege. Does this mean that when I run this
> package, it will implicitly ANALYZE the object? If this is true, then does
> it compute or estimate the statistics?
>
> Your feedback will be appreciated.
>
> Jim
Received on Thu May 20 1999 - 16:49:35 CDT