Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> reducing LIO's

reducing LIO's

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Thu, 31 Mar 2005 17:13:23 +0300
Message-ID: <97b7fd2f050331061328966b7@mail.gmail.com>


Hello list,

We have one query in our trading application thats executed 1770 times in just 20 mintues of time and around 490 users were connected, bascially, this query runs for every tranaction. The problem with this query is, it has a lot of buffers gets and using too much cpu, and when we approch oracle support they ask us to reduce buffers gets, which I understand.
I have done some bench marking, like, I have created one combination index and I have forced index hint to use this query. When I force hint to use newly created index, it reduces cost 50%, but, when I look at buffers gets, it was more than the previous one. Is creating index is the way to reduce LIO? If so, when my buffer gets or more when using index?

my query is having order by and joing of two tables with two columns. server has 9 cpus
buffer cache size is 1600MB
OS : AIX
Oracle 9i

-- 
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia
----------------------------------------------------------------------------------------
"It is your atittude, not your aptitude that determins your altitude."
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 31 2005 - 09:17:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US