how about re-writing the code? post it
On Thu, 31 Mar 2005 17:13:23 +0300, The Human Fly
<sjaffarhussain_at_gmail.com> wrote:
> 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?
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 31 2005 - 09:22:40 CST
