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 -> How to trace the oracle optimizer...

How to trace the oracle optimizer...

From: Yvan GALAS <yvan.galas_at_fr.adp.com>
Date: Thu, 03 Apr 2003 17:59:55 +0200
Message-ID: <b6hlsr$9h7$1@pegase.atos-infogerance.fr> 





Hello



First sorry for my english...



I would like to know how can I trace the oracle optimizer output



The v$slqarea and v$sqltext containt the sql typed in sqlplus tools... 
but how can I get the rebuild order from the optimizer...



Maybe an event or a special init.ora parameter !? Or I missed a sys 
tables !? Do I need to dump the SGA ?



Any advices or tips ?



Thanks by advance...
Received on Thu Apr 03 2003 - 09:59:55 CST












Original text of this message













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