Home » RDBMS Server » Performance Tuning » High Logical Reads (10g R2, 10.2.0.2, win 2003 stnd sp2)
High Logical Reads [message #358771] Wed, 12 November 2008 07:50 Go to next message
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
Re: High Logical Reads [message #358895 is a reply to message #358771] Wed, 12 November 2008 20:30 Go to previous messageGo to next message
rleishman
Messages: 3724
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
Re: High Logical Reads [message #358905 is a reply to message #358895] Wed, 12 November 2008 22:58 Go to previous message
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
Previous Topic: Find speed
Next Topic: Interpreting "Row Source Operation" Output of TKPROF
Goto Forum:
  


Current Time: Sat Dec 10 01:32:57 CST 2016

Total time taken to generate the page: 0.08741 seconds