SELECT plan_table_output FROM
table(DBMS_XPLAN.display_cursor ('&V_SQL_ID',NULL,'ALL' ));
Enter value for v_sql_id: 7pwn4bv77m7vp
old 1: SELECT plan_table_output FROM table(DBMS_XPLAN.display_cursor ('&V_SQL_ID',NULL,'ALL' ))
new 1: SELECT plan_table_output FROM table(DBMS_XPLAN.display_cursor ('7pwn4bv77m7vp',NULL,'ALL' ))
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
SQL_ID 7pwn4bv77m7vp, child number 0
-------------------------------------
select * from rman.titi
Plan hash value: 1230735768
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 3 (100)| |
| 1 | TABLE ACCESS FULL| TITI | 3 | 18 | 3 (0)| 00:00:01 |
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
--------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / TITI@SEL$1
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "TITI"."NAME"[VARCHAR2,30]
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
23 rows selected.
