|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: Heavy I/O on Index File System
Re: Heavy I/O on Index File System
Look at two things
- Oracle parameter optimizer_index_caching, increase it to 50
- Check the sql queries which are doing lots of buffer gets and tune
them
- check the query which are doing Index FF scans and check if that is
the best way , if yes then increase db_file_multiblock_read_count
parameter value.
- Check if lots of nested loops joins are happening and check if they
are the best access path.
--
Posted via dBforums
http://dbforums.com
Received on Mon Nov 26 2001 - 14:12:08 CST
Original text of this message
