Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index creation - performance problem
It may be block cleanout. When select count(*) is executed just after the
table was imported oracle reads & writes.
As I understand block cleanout applies to data block in buffer cache that
have not been written to disk yet ??? (correct me if wrong) while oracle
reads/writes to the table (6GB) that is much bigger than buffer cache
(384MB).
Next time I will try to import just tables then restart the database and
recreate indexes.
Adam
Jonathan Lewis wrote:
> It IS block cleanout.
> Try a select count(*) from table
> before creating the index.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Received on Mon Mar 13 2000 - 00:00:00 CST
![]() |
![]() |