Strange performance problem

2002-09-30 Thread Scott Canaan
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

Re: Strange performance problem

2002-09-30 Thread Babu Nagarajan
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

Re: Strange performance problem

2002-09-30 Thread Babu Nagarajan
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

Re: Strange performance problem

2002-09-30 Thread Babu Nagarajan
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

Temp extent sizes and Strange performance problem

2001-09-19 Thread Cherie_Machler
by: Subject: Re: Strange performance problem [EMAIL PROTECTED] om

Re: Temp extent sizes and Strange performance problem

2001-09-19 Thread Connor McDonald
ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: Re: Strange performance problem [EMAIL

Strange performance problem

2001-09-14 Thread Cherie_Machler
!! 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),

Re: Strange performance problem

2001-09-14 Thread Richard Ji
!! 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

Re: Strange performance problem

2001-09-14 Thread Rachel Carmichael
: 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

Re: Strange performance problem

2001-09-14 Thread Cherie_Machler
: ail.com Subject: Re: Strange performance problem Sent by: [EMAIL PROTECTED