well you rebuild your indexes (why are you doing this - saying FTS doesnt
make sense as FTS's dont use indexes)
if you rebuild indexes it will flood you buffer cache with rubbish so thats
why your ratio is low, so you spend all morning doing PIO's which slow your
users down.
You seem fixed on rebuilding your indexes for everything, you may want to
review that policy
On 9/13/05, Chirag DBA <chiragdba_at_gmail.com> wrote:
>
> Still,
> Well, Users are happy. but in the morning when they run large batch jobs,
> yeah couple of guys do face some problems. As per my observations ,highest
> waits were DB_SEQUENTIAL_WAITS.
> So have done rebuilding of indexes as Sequential reads can be high
> because of the FTS on the tables. Even for the 40GB Database, we have only
> 250 MB SGA so which I am planning to increase. In normal day operation no
> query is getting locked or taking very long to execute.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 13 2005 - 16:11:59 CDT
