New answers tagged

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