Home » RDBMS Server » Performance Tuning » Slow performance for Some queries (Oracle 10g , solaris)
Slow performance for Some queries [message #425098] Wed, 07 October 2009 09:36 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,

One scenario along the slow running queries in PRD m/c

We are running a daliy based batch in our Production environment ,day by day the batch gets slow now the queries gets very slow
for ex
we took the long running query and checked it but in the backend running through TOAD this query returns the data very fast but during the batch the same query takes a long time
there are proper indexes used...
So what could be the problem along this scenario any idea on this whether we can find a change through ORACLE
If means can any one help on this

Thanks in advance
Re: Slow performance for Some queries [message #425100 is a reply to message #425098] Wed, 07 October 2009 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
post EXPLAIN PLAN for both fast & slow queries
Re: Slow performance for Some queries [message #425101 is a reply to message #425098] Wed, 07 October 2009 09:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What else is happening during the "Batch Job"?
Backups? Other Jobs?
Re: Slow performance for Some queries [message #425122 is a reply to message #425098] Wed, 07 October 2009 11:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
there are proper indexes used...

Are there indeed? What exactly does this mean?


How many rows does your query return.
If the answer is 'A lot', then what may be happening is that TOAD is lying to you - it just goes and fetches the first 100 or so rows and displays them - it doesn't fetch all the rows, so the time it takes to return is in no way indicative of the time that it would take to run the whole query.
Previous Topic: db_block_buffer
Next Topic: Predicate Informationn in PLAN
Goto Forum:
  


Current Time: Wed Sep 28 12:40:29 CDT 2016

Total time taken to generate the page: 0.12018 seconds