Re: Heavy I/O on Index File System

From: Ziauddin G. Ahmed <ziasha_at_yahoo.com>
Date: 27 Nov 2001 02:02:57 -0800
Message-ID: <6365e66d.0111270202.79093a98@posting.google.com>

Aviion,

Somebody told me to rebuild all your indexes...would it help ?

aviion <member_at_dbforums.com> wrote in message news:<3c02a218$1_at_usenetgateway.com>...
> Look at two things
>
> 1) Oracle parameter optimizer_index_caching, increase it to 50
>
> 2) Check the sql queries which are doing lots of buffer gets and tune
> them
>
>
> 3) 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.
>
> 4) Check if lots of nested loops joins are happening and check if they
> are the best access path.
Received on Tue Nov 27 2001 - 04:02:57 CST