(由P1即可找出等待块的类列)3)缓冲区所属的段(由P1和P2参数配合视图v$extents即可找出等待块的所属段)select s.segment_name,s.partition_name from dba_extents s where between s.block_id and(s.block_id+s....
对于其它的会话,确定会话的进程ID(SPID),下面的查询识别出名称以A开始的所有用户的会话进程ID: select S.Username,P.Spid from V$SESSION S,V$PROCESS P where S.PADDR=P.ADDR and S.Username like 'A%';(3).以...