Re: why did query behavior change ?
- From: "ed lewis" <eglewis71@xxxxxxxxx>
- To: <denis.sun@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 13 Dec 2010 08:21:15 -0500
As far as I know, traffic has not increased.
Thanks for the response.
----- Original Message -----
From: Denis
To: oracle-l@xxxxxxxxxxxxx
Sent: Friday, December 10, 2010 8:56 AM
Subject: Re: why did query behavior change ?
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@xxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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.
>
Other related posts:
