Re: slow performance

Dont forget to look for disk i/o log jams .... try sar -d 1 10 this will give you a good look at i/o to the disks.... Great Day.... In article <Pine.A41.3.96.980401135510.41570C-100000@orca.cc.metu.edu.tr>, alp koray tasdemir <c066821@orca.cc.metu.edu.tr> writes: > > >> I am running ODS 7.23 u4 on HP 10.20 >> So many users complained about slow performance...I looked at "top".... >> IDLE has been around 21% >> %WCPU 36% == (command) oninit >> %CPU 35% == (command) oninit > > If this slow performance occurs when running a query > it may be because of the optimizer hint parameter; > you can check about the index usages with set explain on; > and decide to use the optimizer or not. > Also if there are many updates and inserts going on around your > databases; it is recommended to run update statistics or > update statistics high once a while.> > Alp Tasdemir > -- trog48 <jbennett> trog48@primenet.com