Re: Question about Package DBMS_SPACE
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 14 May 1999 19:53:34 +0100
Message-ID: <926708195.28684.0.nnrp-12.9e984b29_at_news.demon.co.uk>
Date: Fri, 14 May 1999 19:53:34 +0100
Message-ID: <926708195.28684.0.nnrp-12.9e984b29_at_news.demon.co.uk>
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>...Received on Fri May 14 1999 - 20:53:34 CEST
>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?