<div>
I agree. &nbsp;This looks like an exam question.<br />
<br />
Please provide more information about the specific question you are asking.
</div>


I agree.  This looks like an exam question.

Please provide more information about the specific question you are asking.

<div>
<div class="content wysiwyg-content">
Here which sql query is planned <br />
I am mean analyzed Can you specifiy?<br />
<br />
<br />
Explain plan for Query :<br />
<br />
alter session set current_schema=&lt;schema_nam<wbr />e&gt;;<br />
<br />
select * from table(dbms_xplan.display);<wbr /><br />
<br />
select * from table(dbms_xplan.display_c<wbr />ursor);<br />
<br />
select /*+ gather_plan_statistics */ count(*) from hist_test where id1&gt;1000000;<br />
<br />
select * from table(dbms_xplan.display_c<wbr />ursor(null<wbr />,null,'ALL<wbr />STATS LAST'));<br />
<br />
select distinct sql_id, PLAN_HASH_VALUE,TIMESTAMP from dba_hist_sql_plan where sql_id='&amp;sql_id';
</div>
</div>


Here which sql query is planned 
I am mean analyzed Can you specifiy?


Explain plan for Query :

alter session set current_schema=<schema_name>;

select * from table(dbms_xplan.display);

select * from table(dbms_xplan.display_cursor);

select /*+ gather_plan_statistics */ count(*) from hist_test where id1>1000000;

select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));

select distinct sql_id, PLAN_HASH_VALUE,TIMESTAMP from dba_hist_sql_plan where sql_id='&sql_id';

explain plan

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.