RE: Very high buffer gets
- From: "Nahata, Naveen (US - Glen Mills)" <nnahata@xxxxxxxxxxxx>
- To: <gorbyx@xxxxxxxxx>, <post.ethan@xxxxxxxxx>
- Date: Wed, 15 Feb 2006 08:55:50 -0500
You definitely seem to be correct. When I run the same SQL statement
independently from SQL*PLUS with autotrace enabled, I see only 200 LIOs
instead of the huge no. which I see in the trace file.
Can you please provide a reference to the document which Oracle support
pointed?
Naveen
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alex Gorbachev
Sent: Wednesday, February 15, 2006 4:20 AM
To: post.ethan@xxxxxxxxx
Cc: joseph@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Very high buffer gets
Let me emphasize it again - we were told by Oracle that LIOs attributed
to this statement is somehow wrong - these LIOs are, in fact, from other
statements. I didn't understand why it's accounted in that way (and I
doubt that support guy knew it either), but coalescing/rebuilding
queues' indexes and IOTs helped.
2006/2/14, Ethan Post <post.ethan@xxxxxxxxx>:
Whenever I look at v$sqlarea a couple advanced queue related
statements are always the top statements, however this is
definitely
some sort of bug because you never see these processes eating
all that
much CPU and the numbers reported look down right ridiculous.
--
//www.freelists.org/webpage/oracle-l
--
Best regards,
Alex Gorbachev
This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law. If
you are not the intended recipient, you should delete this message.
Any disclosure, copying, or distribution of this message, or the taking of any
action based on it, is strictly prohibited. [v.E.1]
Other related posts:
