Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Changed execution plans..
Robert,
Seven reasons I can think of include changes to:
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 26-28 London
-----Original Message-----
Freeman
Sent: Sunday, January 19, 2003 1:24 AM
To: Multiple recipients of list ORACLE-L
Hey Ya'all... (still got my southern roots even up here in Chicago!)
Anyone want to throw in some possible reasons why an execution plan
might
change for a given table query....This is on Oracle9iR2 on SUN. I've
looked
at the obvious causes:
None of these seem to apply. I've got a database that a few weeks ago
were
doing indexed
lookups using a partitioned index on a partitioned table. Now, it seems
that
these queries
are doing full table scans on this partitioned table. I'm still
gathering up
the details for the items above (e.g how much have the objects changed)
and
I'll probably run a 10053 trace on one of the bad queries to see what
the
optimizer is doing on Monday, but I'd like to just poll for some
additional
ideas. I *AM* getting partition elimination (thank goodness) but I've
got
two FTS on one partition of this table that are just killing it. They
want
to quantify the reason why this access has changed so I'm trying to
think of
what kinds of stuff I can look at to try to do this.
I will add that this table was just rebuilt recently (through
imp/exp)...
can the change in row to block density make the difference.... hmmmm....
Any ideas??
RF
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Freeman
INET: robertgfreeman_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Cary Millsap
INET: cary.millsap_at_hotsos.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jan 19 2003 - 20:54:09 CST
![]() |
![]() |