OraFAQ Forum: Performance Tuning » High Logical Reads

Home » RDBMS Server » Performance Tuning » High Logical Reads (10g R2, 10.2.0.2, win 2003 stnd sp2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

High Logical Reads [message #358771]

Wed, 12 November 2008 07:50

kummi_gh
Messages: 2
Registered: March 2005
Location: Trichy

Junior Member

Hi All,

We have geodatabase in our production and some of the queries taking more time and CPU usage also high. I have traced and generated TKPROF. I have attached two sample queries in a text file. Please help, how to reduce high consistent gets.

Thanks in advance
Kumar

Attachment: Consistent_gets.txt
(Size: 8.67KB, Downloaded 1645 times)

Report message to a moderator

Re: High Logical Reads [message #358895 is a reply to message #358771]

Wed, 12 November 2008 20:30

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

You are reading 10M+ rows via an index. This is typically a bad idea - Full Scans are orders of magnitude faster than index scans for large volumes.

Look at this article for more: http://www.orafaq.com/node/1981

Ross Leishman

Report message to a moderator

Re: High Logical Reads [message #358905 is a reply to message #358895]

Wed, 12 November 2008 22:58

kummi_gh
Messages: 2
Registered: March 2005
Location: Trichy

Junior Member

Hi Leishman,

Thanks for your feedback and nice article. Those quries are in application level, we will try to tune them.

Kumar

Report message to a moderator

Previous Topic:	Find speed
Next Topic:	Interpreting "Row Source Operation" Output of TKPROF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 02:29:39 CST 2024