Re: Index creation - performance problem

From: Adam Roze <arz_at_royalpbk.com>
Date: 2000/03/13
Message-ID: <38CCC838.319D35FE@royalpbk.com>#1/1

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