SQL_TEXT SQL_ID ELAPSED_TIME CPU_TIME USER_IO_WAIT_TIME
------------------------------ ------------- ---------------- ---------------- -----------------
SELECT * FROM SY812.F9312 W apuhv2c38k7xm 309244127165 84747562500 239519070763
HERE ( SHUSER = :KEY1 AND SHM
KEY = :KEY2 AND SHUPMJ = :KEY3
AND SHUPMT = :KEY4 )
select plan_table_output from table(dbms_xplan.display_cursor('apuhv2c38k7xm',null,'basic'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------
EXPLAINED SQL STATEMENT:
------------------------
SELECT * FROM SY812.F9312 WHERE ( SHUSER = :KEY1 AND SHMKEY = :KEY2
AND SHUPMJ = :KEY3 AND SHUPMT = :KEY4 )
Plan hash value: 2074089509
-----------------------------------
| Id | Operation | Name |
-----------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL| F9312 |
-----------------------------------
Komentáře
