New answers tagged oracle-11g-r2
2
Overview of Optimizer Hints
... A statement block can have only one comment containing hints, ...
select /*+gather_plan_statistics no_index(t idx1_dimcustomer) */
*
from mi_dimcustomer t
where t.customer_num = 12;
1
PL/SQL Developer implicitly executes additional statements in the background.
dbms_xplan.display_cursor(null,null,'basic') returns information from the previously executed statement. It was begin :id := sys.dbms_transaction.local_transaction_id; end;.
After executing your SQL, find it in V$SQL, example:
select sql_id, child_number, sql_text from v$sql
where ...
1
Answer to your 1st question
NO this is explain plan and not execution plan.
EXPLAIN PLAN command - displays an explain plan for a SQL statement without actually executing the statement.
Answer to your 2nd Question:
Below will show execution plan of last executed SQL in the current session
Select plan_table_output from table(dbms_xplan.display_cursor(null,...
Top 50 recent answers are included
