• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

explain plan

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';
1 Solution
slightwv (䄆 Netminder) Commented:
I agree.  This looks like an exam question.

Please provide more information about the specific question you are asking.
DavidSenior Oracle Database AdministratorCommented:
Jcob, we serve best when the asker has tried to find his/her own answer and has become stuck...  The old "teach how to fish" adage.

My two cents, read for familiarity the existing docs and then ask for clarification:
jcob_lAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now