Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about Package DBMS_SPACE
Based on the actual performance it is clear that
it cannot be doing this, but I have never checked
exactly what it does do.
My assumption is that it reads the segment header block to find the high water mark, and the start of the free lists/free list groups, and then runs along the linked listed of the free list to count free blocks up to the limit you have specified.
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
James Hull wrote in message <7hhr7i$n7u$1_at_netnews.upenn.edu>...
>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?
Received on Fri May 14 1999 - 13:53:34 CDT