Following on from my last post as there does not seem to be a built in function for formatting code 'inside' the database. The next best thing sems to be to use sql developer to do this. I'm using v4 but I'm guessing this option has been around for a while.
To format your code nicely simple right click inside sql worksheet and choose the format option:
You'll then end up with something that looks really quite nice - it doesn't paste that well into this blog though as I still can't get SQL nicely formatted here no matter what i seem to try - it is still more readable than the original extract from DBMS_UTILITY though.
SELECT "A1"."SADDR" "SADDR",
"A1"."SID" "SID",
"A1"."SERIAL#" "SERIAL#",
"A1"."AUDSID" "AUDSID",
"A1"."PADDR" "PADDR",
"A1"."USER#" "USER#",
"A1"."USERNAME" "USERNAME",
"A1"."COMMAND" "COMMAND",
"A1". "OWNERID" "OWNERID",
"A1"."TADDR" "TADDR",
"A1"."LOCKWAIT" "LOCKWAIT",
"A1"."STATUS" "STATUS",
"A1"."SERVER" "SERVER",
"A1"."SCHEMA#" "SCHEMA#",
"A1"."SCHEMANAME" "SCHEMANAME",
"A1"."OSUSER" "OSUSER",
"A1"."PROCESS" "PROCESS",
"A1"."MACHINE" "MACHINE",
"A1"."PORT" " PORT",
"A1"."TERMINAL" "TERMINAL",
"A1"."PROGRAM" "PROGRAM",
"A1"."TYPE" "TYPE",
"A1"."SQL_ADDRESS" "SQL_ADDRESS",
"A1"."SQL_HASH_VALUE" "SQL_HASH_VALUE",
"A1"."SQL_ID" "SQL_ID",
"A1"."SQL_CHILD_NUMBER" "SQL_CHILD_NUMBER",
"A1"."SQL_EXEC_START" "SQL_EXEC_START",
"A1"."SQL_EXEC_ID" "SQL_EXEC_ID",
"A1"."PREV_SQL_ADDR" "PREV_SQL_ADDR",
"A1"."PREV_HASH_VALUE" "PREV_HASH_VALUE",
"A1"."PREV_SQL_ID" "PREV_SQL_ID",
"A1"."PREV_CHILD_NUMBER" "PREV_CHILD_NUMBER",
"A1"."PREV_EXEC_START" "PREV_EXEC_START",
"A1"."PREV_EXEC_ID" "PREV_EXEC_ID",
"A1"."PLSQL_ENTRY_OBJECT_ID" "PLSQL_ENTRY_OBJECT_ID",
"A1"."PLSQL_ENTRY_SUBPROGRAM_ID" "PLSQL_ENTRY_SUBPROGRAM_ID",
"A1"."PLSQL_OBJECT_ID" "PLSQL_OBJECT_ID",
"A1"."PLSQL_SUBPROGRAM_ID" "PLSQL_SUBPROGRAM_ID",
"A1"."MODULE" "MODULE",
"A1"."MODULE_HASH" "MODULE_HASH",
"A1"."ACTION" "ACTION",
"A1"."ACTION_HASH" "ACTION_HASH",
"A1"."CLIENT_INFO" "CLIENT_INFO",
"A1"."FIXED_TABLE_SEQUENCE" "FIXED_TABLE_SEQUENCE",
"A1"."ROW_WAIT_OBJ#" "ROW_WAIT_OBJ#",
"A1"."ROW_WAIT_FILE#" "ROW_WAIT_FILE#",
"A1"."ROW_WAIT_BLOCK#" "ROW_WAIT_BLOCK#",
"A1"."ROW_WAIT_ROW#" "ROW_WAIT_ROW#",
"A1"."TOP_LEVEL_CALL#" "TOP_LEVEL_CALL#",
"A1"."LOGON_TIME" "LOGON_TIME",
"A1"."LAST_CALL_ET" "LAST_CALL_ET",
"A1"."PDML_ENABLED" "PDML_ENABLED",
"A1"."FAILOVER_TYPE" "FAILOVER_TYPE",
"A1"."FAILOVER_METHOD" "FAILOVER_METHOD",
"A1"."FAILED_OVER" "FAILED_OVER",
"A1"."RESOURCE_CONSUMER_GROUP" "RESOURCE_CONSUMER_GROUP",
"A1"."PDML_STATUS" "PDML_STATUS",
"A1"."PDDL_STATUS" "PDDL_STATUS",
"A1"."PQ_STATUS" "PQ_STATUS",
"A1"."CURRENT_QUEUE_DURATION" "CURRENT_QUEUE_DURATION",
"A1"."CLIENT_IDENTIFIER" "CLIENT_IDENTIFIER",
"A1"."BLOCKING_SESSION_STATUS" "BLOCKING_SESSION_STATUS",
"A1"."BLOCKING_INSTANCE" "BLOCKING_INSTANCE",
"A1"."BLOCKING_SESSION" "BLOCKING_SESSION",
"A1"."FINAL_BLOCKING_SESSION_STATUS" "FINAL_BLOCKING_SESSION_STATUS",
"A1"."FINAL_BLOCKING_INSTANCE" "FINAL_BLOCKING_INSTANCE",
"A1"."FINAL_BLOCKING_SESSION" "FINAL_BLOCKING_SESSION",
"A1"."SEQ#" "SEQ#",
"A1"."EVENT#" "EVENT#",
"A1"."EVENT" "EVENT",
"A1"."P1TEXT" "P1TEXT",
"A1"."P1" "P1",
"A1"."P1RAW" "P1RAW",
"A1"."P2TEXT" "P2TEXT" ,
"A1"."P2" "P2",
"A1"."P2RAW" "P2RAW",
"A1"."P3TEXT" "P3TEXT",
"A1"."P3" "P3",
"A1"."P3RAW" "P3RAW",
"A1"."WAIT_CLASS_ID" "WAIT_CLASS_ID",
"A1"."WAIT_CLASS#" "WAIT_CLASS#",
"A1"."WAIT_CLASS" "WAIT_CLASS",
"A1"."WAIT_TIME" "WAIT_TIME",
"A1"."SECONDS_IN_WAIT" "SECONDS_IN_WAIT",
"A1"."STATE" "STATE",
"A1"."WAIT_TIME_MICRO" "WAIT_TIME_MICRO",
"A1"."TIME_REMAINING_MICRO" "TIME_REMAINING_MICRO",
"A1" ."TIME_SINCE_LAST_WAIT_MICRO" "TIME_SINCE_LAST_WAIT_MICRO",
"A1"."SERVICE_NAME" "SERVICE_NAME",
"A1"."SQL_TRACE" "SQL_TRACE",
"A1". "SQL_TRACE_WAITS" "SQL_TRACE_WAITS",
"A1"."SQL_TRACE_BINDS" "SQL_TRACE_BINDS",
"A1"."SQL_TRACE_PLAN_STATS" "SQL_TRACE_PLAN_STATS",
"A1"."SESSION_EDITION_ID" "SESSION_EDITION_ID",
"A1"."CREATOR_ADDR" "CREATOR_ADDR",
"A1"."CREATOR_SERIAL#" "CREATOR_SERIAL#",
"A1". "ECID" "ECID",
"A1"."SQL_TRANSLATION_PROFILE_ID" "SQL_TRANSLATION_PROFILE_ID",
"A1"."PGA_TUNABLE_MEM" "PGA_TUNABLE_MEM",
"A1"."CON_ID" "CON_ID",
"A1"."EXTERNAL_NAME" "EXTERNAL_NAME"
FROM
(SELECT "A2"."SADDR" "SADDR",
"A2"."SID" "SID",
"A2"."SERIAL#" "SERIAL#",
" A2"."AUDSID" "AUDSID",
"A2"."PADDR" "PADDR",
"A2"."USER#" "USER#",
"A2"."USERNAME" "USERNAME",
"A2"."COMMAND" "COMMAND",
"A2"."OWNERID" "OWNERID",
"A2"."TADDR" "TADDR",
"A2"."LOCKWAIT" "LOCKWAIT",
"A2"."STATUS" "STATUS",
"A2"."SERVER" "SERVER",
"A2"."SCHEMA#" "SCHEMA#",
"A2"."SCHEMANAME" "SCHEMANAME",
"A2"."OSUSER" "OSUSER",
"A2"."PROCESS" "PROCESS",
"A2"."MACHINE" "MACHINE",
"A2"."PORT" "PORT",
" A2"."TERMINAL" "TERMINAL",
"A2"."PROGRAM" "PROGRAM",
"A2"."TYPE" "TYPE",
"A2"."SQL_ADDRESS" "SQL_ADDRESS",
"A2"."SQL_HASH_VALUE" "SQL_HASH_VALUE",
"A2"."SQL_ID" "SQL_ID",
"A2"."SQL_CHILD_NUMBER" "SQL_CHILD_NUMBER",
"A2"."SQL_EXEC_START" "SQL_EXEC_START",
"A2"."SQL_EXEC_ID" "SQL_EXEC_ID",
"A2"."PREV_SQL_ADDR" "PREV_SQL_ADDR",
"A2"."PREV_HASH_VALUE" "PREV_HASH_VALUE",
"A2"."PREV_SQL_ID" "PREV_SQL_ID",
"A2"."PREV_CHILD_NUMBER" "PREV_CHILD_NUMBER",
"A2"."PREV_EXEC_START" "PREV_EXEC_START",
"A2"."PREV_EXEC_ID" "PREV_EXEC_ID",
"A2"."PLSQL_ENTRY_OBJECT_ID" "PLSQL_ENTRY_OBJECT_ID",
"A2"."PLSQL_ENTRY_SUBPROGRAM_ID" "PLSQL_ENTRY_SUBPROGRAM_ID",
"A2"."PLSQL_OBJECT_ID" "PLSQL_OBJECT_ID",
"A2"."PLSQL_SUBPROGRAM_ID" "PLSQL_SUBPROGRAM_ID",
"A2"."MODULE" "MODULE",
"A2"."MODULE_HASH" "MODULE_HASH",
"A2"."ACTION" "ACTION",
"A2"."ACTION_HASH" "ACTION_HASH",
"A2"."CLIENT_INFO" "CLIENT_INFO",
"A2"."FIXED_TABLE_SEQUENCE" "FIXED_TABLE_SEQUENCE",
"A2"."ROW_WAIT_OBJ#" "ROW_WAIT_OBJ#",
"A2"."ROW_WAIT_FILE#" "ROW_WAIT_FILE#",
"A2"."ROW_WAIT_BLOCK#" "ROW_WAIT_BLOCK#",
"A2"."ROW_WAIT_ROW#" "ROW_WAIT_ROW#",
"A2"."TOP_LEVEL_CALL#" "TOP_LEVEL_CALL#",
"A2"."LOGON_TIME" "LOGON_TIME",
"A2"."LAST_CALL_ET" "LAST_CALL_ET",
"A2"."PDML_ENABLED" "PDML_ENABLED",
"A2"."FAILOVER_TYPE" "FAILOVER_TYPE",
"A2"."FAILOVER_METHOD" "FAILOVER_METHOD",
"A2"."FAILED_OVER" "FAILED_OVER",
"A2"."RESOURCE_CONSUMER_GROUP" "RESOURCE_CONSUMER_GROUP",
"A2"."PDML_STATUS" "PDML_STATUS" ,
"A2"."PDDL_STATUS" "PDDL_STATUS",
"A2"."PQ_STATUS" "PQ_STATUS",
"A2"."CURRENT_QUEUE_DURATION" "CURRENT_QUEUE_DURATION",
"A2"."CLIENT_IDENTIFIER" "CLIENT_IDENTIFIER",
"A2"."BLOCKING_SESSION_STATUS" "BLOCKING_SESSION_STATUS",
"A2"."BLOCKING_INSTANCE" "BLOCKING_INSTANCE",
"A2"."BLOCKING_SESSION" "BLOCKING_SESSION",
"A2"."FINAL_BLOCKING_SESSION_STATUS" "FINAL_BLOCKING_SESSION_STATUS",
"A2"."FINAL_BLOCKING_INSTANCE" "FINAL_BLOCKING_INSTANCE",
"A2"."FINAL_BLOCKING_SESSION" "FINAL_BLOCKING_SESSION",
"A2"."SEQ#" "SEQ#",
"A2" ."EVENT#" "EVENT#",
"A2"."EVENT" "EVENT",
"A2"."P1TEXT" "P1TEXT",
"A2"."P1" "P1",
"A2"."P1RAW" "P1RAW",
"A2"."P2TEXT" "P2TEXT",
"A2"." P2" "P2",
"A2"."P2RAW" "P2RAW",
"A2"."P3TEXT" "P3TEXT",
"A2"."P3" "P3",
"A2"."P3RAW" "P3RAW",
"A2"."WAIT_CLASS_ID" "WAIT_CLASS_ID",
"A2"."WAIT_CLASS#" "WAIT_CLASS#",
"A2"."WAIT_CLASS" "WAIT_CLASS",
"A2"."WAIT_TIME" "WAIT_TIME",
"A2"."SECONDS_IN_WAIT" "SECONDS_IN_WAIT",
"A2"."STATE" "STATE",
"A2"."WAIT_TIME_MICRO" "WAIT_TIME_MICRO",
"A2"."TIME_REMAINING_MICRO" "TIME_REMAINING_MICRO",
"A2"."TIME_SINCE_LAST_WAIT_MICRO" "TIME_SINCE_LAST_WAIT_MICRO",
"A2"."SERVICE_NAME" "SERVICE_NAME",
"A2"."SQL_TRACE" "SQL_TRACE",
"A2"."SQL_TRACE_WAITS" "SQL_TRACE_WAITS",
"A2"."SQL_TRACE_BINDS" "SQL_TRACE_BINDS",
"A2"."SQL_TRACE_PLAN_STATS" "SQL_TRACE_PLAN_STATS",
"A2"."SESSION_EDITION_ID" "SESSION_EDITION_ID",
"A2"."CREATOR_ADDR" "CREATOR_ADDR",
"A2"."CREATOR_SERIAL#" "CREATOR_SERIAL#",
"A2"."ECID" "ECID",
"A2"."SQL_TRANSLATION_PROFILE_ID" "SQL_TRANSLATION_PROFILE_ID",
"A2"."PGA_TUNABLE_MEM" "PGA_TUNABLE_MEM",
"A2"."CON_ID" "CON_ID",
"A2"."EXTERNAL_NAME" "EXTERNAL_NAME"
FROM
(SELECT "A5"."INST_ID" "INST_ID",
"A5"."ADDR" "SADDR",
"A5"."INDX" "SID",
"A5"."KSUSESER" "SERIAL#",
"A5"."KSUUDSES" "AUDSID",
"A5"."KSUSEPRO" "PADDR",
"A5"."KSUUDLUI" "USER#",
"A5"."KSUUDLNA" "USERNAME",
"A5"."KSUUDOCT" "COMMAND",
"A5"."KSUSESOW" "OWNERID",
DECODE("A5"."KSUSETRN",HEXTORAW('00'),NULL,"A5"."KSUSETRN") "TADDR",
DECODE("A5"."KSQPSWAT",HEXTORAW('00'),NULL,"A5"."KSQPSWAT") "LOCKWAIT",
DECODE(BITAND("A5"."KSUSEIDL",11),1,'ACTIVE',0,DECODE(BITAND("A5"."KSUSEFLG",4096),0,'INACTIVE','CACHED'),2,'SNIPED',3,'SNIPED','KILLED') "STATUS",
DECODE("A5"."KSSPATYP",1,'DEDICATED',2,'SHARED',3,'PSEUD
O',4,'POOLED','NONE') "SERVER",
"A5"."KSUUDSID" "SCHEMA#",
"A5"."KSUUDSNA" "SCHEMANAME",
"A5"."KSUSEUNM" "OSUSER",
"A5"."KSUSEPID" " PROCESS",
"A5"."KSUSEMNM" "MACHINE",
"A5"."KSUSEMNP" "PORT",
"A5"."KSUSETID" "TERMINAL",
"A5"."KSUSEPNM" "PROGRAM",
DECODE(BITAND("A5"."KSUSEFLG",19),17,'BACKGROUND',1,'USER',2,'RECURSIVE','?') "TYPE",
"A5"."KSUSESQL" "SQL_ADDRESS",
"A5"."KSUSESQH" "SQL_HASH_VALUE",
"A5"."KSUSESQI" "SQL_ID",
DECODE("A5"."KSUSESCH",65535,TO_NUMBER(NULL),"A5"."KSUSESCH") "SQL_CHILD_NUMBER",
"A5"."KSUSESESTA" " SQL_EXEC_START",
DECODE("A5"."KSUSESEID",0,TO_NUMBER(NULL),"A5"."KSUSESEID") "SQL_EXEC_ID",
"A5"."KSUSEPSQ" "PREV_SQL_ADDR",
"A5"." KSUSEPHA" "PREV_HASH_VALUE",
"A5"."KSUSEPSI" "PREV_SQL_ID",
DECODE("A5"."KSUSEPCH",65535,TO_NUMBER(NULL),"A5"."KSUSEPCH") "PREV_CHILD_NUMBER",
"A5"."KSUSEPESTA" "PREV_EXEC_START",
DECODE("A5"."KSUSEPEID",0,TO_NUMBER(NULL),"A5"."KSUSEPEID") "PREV_EXEC_ID",
DECOD E("A5"."KSUSEPEO",0,TO_NUMBER(NULL),"A5"."KSUSEPEO") "PLSQL_ENTRY_OBJECT_ID",
DECODE("A5"."KSUSEPEO",0,TO_NUMBER(NULL),"A5"."KSUSEPES") "PLSQL_ENTRY_SUBPROGRAM_ID",
DECODE("A5"."KSUSEPCO",0,TO_NUMBER(NULL),DECODE(BITAND("A5"."KSUSSTMBV",POWER(2,11)),POWER(2, 11),"A5"."KSUSEPCO",TO_NUMBER(NULL))) "PLSQL_OBJECT_ID",
DECODE("A5"."KSUSEPCS",0,TO_NUMBER(NULL),DECODE(BITAND("A5"."KSUSSTMBV", POWER(2,11)),POWER(2,11),"A5"."KSUSEPCS",TO_NUMBER(NULL))) "PLSQL_SUBPROGRAM_ID",
"A5"."KSUSEAPP" "MODULE",
"A5"."KSUSEAPH" "MODULE_HASH",
"A5"."KSUSEACT" "ACTION",
"A5"."KSUSEACH" "ACTION_HASH",
"A5"."KSUSECLI" "CLIENT_INFO",
"A5"."KSUSEFIX" "FIXED_TABLE_SEQUENCE",
"A5"."KSUSEOBJ" "ROW_WAIT_OBJ#",
"A5"."KSUSEFIL" "ROW_WAIT_FILE#",
"A5"."KSUSEBLK" "ROW_WAIT_BLOCK#",
"A5"."KSUSESLT" "ROW_WAIT_ROW#",
"A5"."KSUSEORAFN" "TOP_LEVEL_CALL#",
"A5"."KSUSELTM" "LOGON_TIME",
"A5"."KSUSECTM" "LAST_CALL_ET",
DECODE(BITAND("A5"."KSUSEPXOPT",12),0,'NO','YES') "PDML_ENABLED",
DECODE("A5"."KSUSEFT",2,'SESSION',4,'SELECT',8,'TRANSACTIONAL','NONE') "FAILOVER_TYPE",
D ECODE("A5"."KSUSEFM",1,'BASIC',2,'PRECONNECT',4,'PREPARSE','NONE') "FAILOVER_METHOD",
DECODE("A5"."KSUSEFS",1,'YES','NO') "FAILED_OVER",
"A5"."KSUSEGRP" "RESOURCE_CONSUMER_GROUP",
DECODE(BITAND("A5"."KSUSEPXOPT",4),4,'ENABLED',DECODE(BITAND("A5"."KSUSEPXOPT", 8),8,'FORCED','DISABLED')) "PDML_STATUS",
DECODE(BITAND("A5"."KSUSEPXOPT",2),2,'FORCED',DECODE(BITAND("A5"."KSUSEPXOPT",1),1,'DIS
ABLED','ENABLED')) "PDDL_STATUS",
DECODE(BITAND("A5"."KSUSEPXOPT",32),32,'FORCED',DECODE(BITAND("A5"."KSUSEPXOPT",16),16,'DISABLE
D','ENABLED')) "PQ_STATUS",
"A5"."KSUSECQD" "CURRENT_QUEUE_DURATION",
"A5"."KSUSECLID" "CLIENT_IDENTIFIER",
DECODE("A5"."KSUSEBLOCKER",4294967295,'UNKNOWN',4294967294,'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER',4294967291,'NOT IN WAIT','VALID') "BLOCKING_SESSION_STATUS",
DECODE("A5"."KSUSEBLOCKER",4294967295,TO_NUMBER(NULL),4294967294,TO_NUMBER(NULL),4294967293,TO_NUMBER(NULL ),4294967292,TO_NUMBER(NULL),4294967291,TO_NUMBER(NULL),BITAND("A5"."KSUSEBLOCKER",2147418112)/65536) "BLOCKING_INSTANCE",
DECODE ("A5"."KSUSEBLOCKER",4294967295,TO_NUMBER(NULL),4294967294,TO_NUMBER(NULL),4294967293,TO_NUMBER(NULL),4294967292,TO_NUMBER(NULL) ,4294967291,TO_NUMBER(NULL),BITAND("A5"."KSUSEBLOCKER",65535)) "BLOCKING_SESSION",
DECODE("A5"."KSUSEFBLOCKER",4294967295,'UNKNOW
N',4294967294,'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER',4294967291,'NOT IN WAIT','VALID') "FINAL_BLOCKING_SESSION_STATUS",
DECODE("A5"."KSUSEFBLOCKER",4294967295,TO_NUMBER(NULL),4294967294,TO_NUMBER(NULL),4294967293,TO_NUMBER(NULL),4294967292,TO _NUMBER(NULL),4294967291,TO_NUMBER(NULL),BITAND("A5"."KSUSEFBLOCKER",2147418112)/65536) "FINAL_BLOCKING_INSTANCE",
DECODE("A5"."KSUSEFBLOCKER",4294967295,TO_NUMBER(NULL),4294967294,TO_NUMBER(NULL),4294967293,TO_NUMBER(NULL),4294967292,TO_NUMBER(NULL),429496 7291,TO_NUMBER(NULL),BITAND("A5"."KSUSEFBLOCKER",65535)) "FINAL_BLOCKING_SESSION",
"A3"."KSLWTSEQ" "SEQ#",
"A3"."KSLWTEVT" "EVENT#",
"A4"."KSLEDNAM" "EVENT",
"A4"."KSLEDP1" "P1TEXT",
"A3"."KSLWTP1" "P1",
"A3"."KSLWTP1R" "P1RAW",
"A4"."KSLEDP2" "P2TEXT",
"A3"."KSLWTP2" "P2",
"A3"."KSLWTP2R" "P2RAW",
"A4"."KSLEDP3" "P3TEXT",
"A3"."KSLWTP3" "P3",
"A3"."KSLWTP3R" "P3RAW",
"A4"."KSLEDCLASSID" "WAIT_CLASS_ID",
"A4"."KSLEDCLASS#" "WAIT_CLASS#",
"A4"."KSLEDCLASS" "WAIT_CLASS",
DECODE("A3"."KSLWTINWAIT",0,DECODE(BITAND("A3"."KSLWTFLAGS",256),0,( -2),DECODE(ROUND("A3"."KSLWTSTIME"/10000),0,(-1),ROUND("A3"."KSLWTSTIME"/10000))),0) "WAIT_TIME",
DECODE("A3"."KSLWTINWAIT",0,ROUND(("A3"."KSLWTSTIME" +"A3"."KSLWTLTIME")/1000000),ROUND("A3"."KSLWTSTIME"/1000000)) "SECONDS_IN_WAIT",
DECODE("A3". "KSLWTINWAIT",1,'WAITING',DECODE(BITAND("A3"."KSLWTFLAGS",256),0,'WAITED UNKNOWN TIME',DECODE(ROUND("A3"."KSLWTSTIME"/10000),0,'
WAITED SHORT TIME','WAITED KNOWN TIME'))) "STATE",
"A3"."KSLWTSTIME" "WAIT_TIME_MICRO",
DECODE("A3"."KSLWTINWAIT",0,TO_NUMBER(NULL ),DECODE(BITAND("A3"."KSLWTFLAGS",64),64,0,"A3"."KSLWTTREM")) "TIME_REMAINING_MICRO",
"A3"."KSLWTLTIME" "TIME_SINCE_LAST_WAIT_MICRO",
"A5"."KSUSESVC" "SERVICE_NAME",
DECODE(BITAND("A5"."KSUSEFLG2",32),32,'ENABLED','DISABLED') "SQL_TRACE",
DECODE(BITAND("A5"."KSUSEFLG2",64),64,'TRUE','FALSE') "SQL_TRACE_WAITS",
DECODE(BITAND("A5"."KSUSEFLG2",128),128,'TRUE','FALSE') "SQL_TRACE_BINDS",
DEC ODE(BITAND("A5"."KSUSEFLG2",65536)+BITAND("A5"."KSUSEFLG2",131072),65536,'ALL EXEC',131072,'NEVER',0,'FIRST EXEC') "SQL_TRACE_PLAN_STATS",
"A5"."KSUUDSAE" "SESSION_EDITION_ID",
"A5"."KSUSECRE" "CREATOR_ADDR",
"A5"."KSUSECSN" "CREATOR_SERIAL#",
"A5"."KSUSEECID" "ECID",
"A5"."KSUUDTXLP" "SQL_TRANSLATION_PROFILE_ID",
("A5"."KSUSEPGAMAN"+"A5"."KSUSEPGAAUTO")*1024 "PGA_TUNABLE_MEM",
"A5"."CON_ID" "CON_ID",
"A5"."KSUSEXNM" "EXTERNAL_NAME"
FROM SYS."X$KSUSE" "A5",
SYS."X$KSLED" "A4",
SYS."X$KSLWT" "A3"
WHERE BITAND("A5"."KSSPAFLG",1)<>0
AND BITAND("A5"."KSUSEFLG",1) <>0
AND "A5"."INDX" ="A3"."KSLWTSID"
AND "A3"."KSLWTEVT" ="A4"."INDX"
) "A2"
WHERE "A2". "INST_ID"=USERENV('INSTANCE')
) "A1"
Comments
Post a Comment