I got a call from a customer earlier. He said that he was trying to
run a query and it was taking way too long. He ran the same query last
Friday and it came back in seconds. I looked at it in OEM and noticed
that two of the tables were being accessed by full table scans. These
tables
I have seen something like this in the past and it was because there were
two tables - named the same in two different schemas (public synonym,
private synonym and all that mess)..
Do you know whether this could be the same case as yours?
Also check to see if the explain plan differs when u run
I have seen something like this in the past and it was because there were
two tables - named the same in two different schemas (public synonym,
private synonym and all that mess)..
Do you know whether this could be the same case as yours?
Also check to see if the explain plan differs when u run
I have seen something like this in the past and it was because there were
two tables - named the same in two different schemas (public synonym,
private synonym and all that mess)..
Do you know whether this could be the same case as yours?
Also check to see if the explain plan differs when u run
by: Subject: Re: Strange performance problem
[EMAIL PROTECTED]
om
ORACLE-L
[EMAIL PROTECTED]
m cc:
Sent by: Subject:
Re: Strange performance problem
[EMAIL
!! Please do not post Off Topic to this List !!
I have a nightly load job that was being tracked by our developers.
According to their nightly logs (going back months), a query was running
as far back as they can record with a sub-second response time.
Then on a particular date (Aug. 23rd),
!! Please do not post Off Topic to this List !!
Did you check to see if there is anything else running on the server that might take
resource away from Oracle? It has happened to me once that the SA was
running something that he shouldn't and it's using a lot of system resources.
HTH
[EMAIL
: Strange performance problem
Date: Fri, 14 Sep 2001 11:05:29 -0800
!! Please do not post Off Topic to this List !!
I have a nightly load job that was being tracked by our developers.
According to their nightly logs (going back months), a query was running
as far back as they can record with a sub
:
ail.com Subject: Re: Strange performance problem
Sent by:
[EMAIL PROTECTED
10 matches
Mail list logo