Re: reducing LIO's

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 31 Mar 2005 15:18:56 +0100

how about re-writing the code?  post it

On Thu, 31 Mar 2005 17:13:23 +0300, The Human Fly
<sjaffarhussain@xxxxxxxxx> 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?

Other related posts: