Oracle 通过 SID 查询 SESSION 和 SQL 信息

setlinesize260setpagesize1000colsidfor99999colspidfora8coleventfora30colmodulefora35colmachinefora15colusernamefora10colholderfora10colfinalfora10colsql_idfora15colexec_getsfor99999999colsecondsfora5colobject_idfor999999colparamfora30colsql_textfora6colPGA_USEfor9999altersessionsetnls_date_format='yyyy-mm-dd hh24:mi:ss';
selecta.sid,
a.username,
a.machine,
a.module,
a.event,
a.sql_id,
round(decode(c.executions,0,buffer_gets,buffer_gets/executions)) exec_gets,
a.ROW_WAIT_OBJ#object_id,
a.BLOCKING_INSTANCE||'_'||a.blocking_sessionholder,
a.FINAL_BLOCKING_INSTANCE||'_'||a.FINAL_BLOCKING_SESSIONfinal,
to_char(LAST_CALL_ET) seconds,
a.p1||'_'||a.p2||'_'||a.p3param,
b.spid,
trunc(b.PGA_USED_MEM/1024/1024,2) asPGA_USE,
substr(c.sql_text,0,6) sql_textfromv$sessiona, v$processb,v$sqlcwherea.paddr=b.addr(+)
anda.status='ACTIVE'andnot (a.type='BACKGROUND'anda.state='WAITING'anda.wait_class='Idle')
anda.sql_id=c.sql_id(+)
anda.sql_child_number=c.CHILD_NUMBER(+)
andb.spid='&SPID'orderbya.sql_id, a.machine;