clear screen<\/p>\n
set verify off<\/p>\n
set pagesize 200<\/p>\n
set linesize 110<\/p>\n
set embedded off<\/p>\n
set feedback off<\/p>\n
col col0 format a25 heading “Sid-Serial”<\/p>\n
col col1 format a10 heading “UserName”<\/p>\n
col col2 format a10 heading “Schema”<\/p>\n
col col3 format a10 heading “OsUser”<\/p>\n
col col4 format a10 heading “Process”<\/p>\n
col col5 format a10 heading “Machine”<\/p>\n
col col6 format a10 heading “Terminal”<\/p>\n
col col7 format a20 heading “Program”<\/p>\n
col col8 format 9 heading “Piece”<\/p>\n
col col9 format a8 heading “Status”<\/p>\n
col col10 format a64 heading “SQL”<\/p>\n
!rm -f .\/cpu_overhead.lst<\/p>\n
spool cpu_overhead.lst<\/p>\n
Select A.sid||’,’||A.serial# col0,<\/p>\n
A.username col1,<\/p>\n
A.schemaname col2,<\/p>\n
A.osuser col3,<\/p>\n
A.process col4,<\/p>\n
A.machine col5,<\/p>\n
A.Terminal col6,<\/p>\n
upper(A.program) col7,<\/p>\n
C.piece col8,<\/p>\n
A.status col9,<\/p>\n
C.sql_text col10<\/p>\n
From v$session A, v$process B, v$sqltext C<\/p>\n
Where B.spid = ‘&1’<\/p>\n
and A.paddr = B.addr<\/p>\n
and C.address = A.sql_address<\/p>\n
order by C.piece;<\/p>\n
spool off<\/p>\n","protected":false},"excerpt":{"rendered":"
clear screen set verify off set pagesize 200 set linesize 110 set embedded off set feedback off col col0 format a25 heading “Sid-Serial” col col1 format a10 heading “UserName” col col2 format a10 heading “Schema” col col3 format a10 heading “OsUser” col col4 format a10 heading “Process” col col5 format a10 heading “Machine” col col6 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[177,178],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/423"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=423"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/423\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=423"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}