GV$SQL_WORKAREA
SELECT INST_ID, -- INST_ID NUMBER PHADD_QKSMM, -- ADDRESS RAW(4) HASHV_QKSMM, -- HASH_VALUE NUMBER SQLID_QKSMM, -- SQL_ID VARCHAR2(13) CHILDNO_QKSMM, -- CHILD_NUMBER NUMBER WADDR_QKSMM, -- WORKAREA_ADDRESS RAW(4) substr -- OPERATION_TYPE VARCHAR2(20) (OPERTYPE_QKSMM, 1, 20), to_number -- OPERATION_ID NUMBER (decode (OPERTID_QKSMM, 65535, NULL, OPERTID_QKSMM)), substr -- POLICY VARCHAR2(10) (SIZEPOLICY_QKSMM, 1, 10), OPTIMAL_QKSMM * 1024, -- ESTIMATED_OPTIMAL_SIZE NUMBER ONEPASS_QKSMM * 1024, -- ESTIMATED_ONEPASS_SIZE NUMBER LASTMEM_QKSMM * 1024, -- LAST_MEMORY_USED NUMBER substr -- LAST_EXECUTION VARCHAR2(10) (decode (LASTPASS_QKSMM, 0, 'OPTIMAL', to_char (LASTPASS_QKSMM) || ' PASS' || decode (LASTPASS_QKSMM, 1, '', 'ES')), 1, 10), LASTDOP_QKSMM, -- LAST_DEGREE NUMBER (OPTACTS_QKSMM -- TOTAL_EXECUTIONS NUMBER + SPAACTS_QKSMM + MPAACTS_QKSMM), OPTACTS_QKSMM, -- OPTIMAL_EXECUTIONS NUMBER SPAACTS_QKSMM, -- ONEPASS_EXECUTIONS NUMBER MPAACTS_QKSMM, -- MULTIPASSES_EXECUTIONS NUMBER ATIME_QKSMM, -- ACTIVE_TIME NUMBER to_number -- MAX_TEMPSEG_SIZE NUMBER (decode (MAXTSEG_QKSMM, 0, NULL, MAXTSEG_QKSMM*1024)), to_number -- LAST_TEMPSEG_SIZE NUMBER (decode (LASTTSEG_QKSMM, 0, NULL, LASTTSEG_QKSMM*1024)) FROM X$QKSMMWDS

home |  up  |  mailbox