Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is the best method to collect EXPLAIN PLAN for a lot of SQL statement

Re: What is the best method to collect EXPLAIN PLAN for a lot of SQL statement

From: <dominica_at_gmail.com>
Date: 5 May 2005 15:08:06 -0700
Message-ID: <1115330886.024119.197610@o13g2000cwo.googlegroups.com> 





I think in the oracle upgrade document, it said, "run your explain plan



for those frequent SQL statements and run those same statements after
upgrade."



I agree, I am not looking for exact explain plan(the cost).
I hope to look for better plan after oracle upgrade.



Basically, I want to kind of glance through if certain SQL statement
has a


worst plan than oracle 8.1.7.4, then I will let the developer group
now, and


they would try to tune those particular SQL statements.



I am not bill by hour for this job.





Dominica
Received on Thu May 05 2005 - 17:08:06 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US