Hi,
   Can any one tell me how to see the explain plan or any related features (for example whether it is going thro all created indexes or not) by using view v$sqlarea and its column sql_text.
   Please give me any other suggestions.


Regards,
ramanadyv

Hi
to use explan plan.. u should have right to create table plan table
Then run the script utlxplan (generally located at folowing location)
ORACLE_HOME\rdbms\admin\utlxplan.sql

execute one of the statement..

set autotrace on explain -- generally used (shows data of select stmt followed by plan)
set autotrace on statistics
set autotrace on explain statistics

set autotrace traceonly explain
set autotrace traceonly statistics
set autotrace traceonly explain statistics

set autotrace off explain
set autotrace off statistics
set autotrace off explain statistics


Regards
Milind