Hello World. This is my First of First Blog. Here I will try to write things related to what I learn, Since I am kinda obsessed with Technology’s lineage. I, being a Java professional, love Java profoundly and so tried to make a blog that will help you and me of course to be in touch with new happenings in the field of technology. I may soon start a discussion forum based on Java, for that we need to wait a while, after all , not always, good things are FREE….
There are two ways to view explain plan
1. Go to sql prompt
set autotrace traceonly explain
select 1 from dual
set autotrace off
2. Go to sql prompt
EXPLAIN PLAN FOR
select 1 from dual
and then select from DBMS_XPLAN.DISPLAY table that stores the explain plan for last executed query
SELECT * FROM table(DBMS_XPLAN.DISPLAY);
Posted by Unknown at 12:12 PM
Posts
0 comments:
Post a Comment