RE: Very high buffer gets

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alex Gorbachev Sent: Wednesday, February 15, 2006 4:20 AM To: post.ethan_at_gmail.com
Cc: joseph_at_amalrajinc.com; oracle-l_at_freelists.org 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_at_gmail.com>:

	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. 
	--
	http://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]

--
http://www.freelists.org/webpage/oracle-l