Unless dbms_space is going wrong, it sounds
as if you have a very large number of blocks on
the partition free lists. The sequential reads are
probably oracle walking the free list.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Michael Spellbrink wrote in message
<638121fa.0205220956.7521419e_at_posting.google.com>...
>Hello,
>
>
>I'm using Oracle 8.1.7 and I have some problems with the DBMS_SPACE
>Pck.
>when I try to execute it on Tables,Indexes and Clusters it works fine,
>even with a 'null' scan_limit, but
>when I try to execute it with Partitioned Objects, it takes hours for
>Objects with 1 freelist groups and 1 freelist
>. I tried to trace the session and found out that
>a lot of sequential_reads are going on, just like when i traced the
>execution on a 'normal' table. The partitions are not very big.
>Unfortunately, I can't set the scan_limit to a different value because
>I have to have the whole segment 'scanned'.
>I would greatly appreciate help, thanks folks
>
>Michael Spellbrink
Received on Wed May 22 2002 - 14:16:41 CDT
