| Slow performance for Some queries [message #425098] |
Wed, 07 October 2009 09:36  |
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 #425122 is a reply to message #425098] |
Wed, 07 October 2009 11:19  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
