Re: why did query behavior change ?
From: Denis <denis.sun_at_yahoo.com>
Date: Fri, 10 Dec 2010 05:56:57 -0800 (PST)
Message-ID: <456461.25002.qm_at_web57207.mail.re3.yahoo.com>
Are there write traffic or such traffic suddently increased to the tables you are quering? In such cases, you can find reads from undo. ----- Original Message ----- From: "Daniel Fink" <daniel.fink_at_optimaldba.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, December 08, 2010 5:48 PM Subject: RE: why did query behavior change ? > Did this impact *every* query accessing this table? Yes > What were the differences in the execution plans? None > What were the differences in the execution profiles (changes in physical > i/o, consistent gets, cpu time, wait time)? Don't have that info. > When were statistics last gathered on the table? within the last week > Were there any systemic changes? None that I am aware of. >
Date: Fri, 10 Dec 2010 05:56:57 -0800 (PST)
Message-ID: <456461.25002.qm_at_web57207.mail.re3.yahoo.com>
Are there write traffic or such traffic suddently increased to the tables you are quering? In such cases, you can find reads from undo. ----- Original Message ----- From: "Daniel Fink" <daniel.fink_at_optimaldba.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, December 08, 2010 5:48 PM Subject: RE: why did query behavior change ? > Did this impact *every* query accessing this table? Yes > What were the differences in the execution plans? None > What were the differences in the execution profiles (changes in physical > i/o, consistent gets, cpu time, wait time)? Don't have that info. > When were statistics last gathered on the table? within the last week > Were there any systemic changes? None that I am aware of. >
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 10 2010 - 07:56:57 CST