正德厚生,臻于至善

缓解焦虑v$session

set lines 200 pages 50000
col event for a50
col sql_id for a20
col final_blocking_session for 9999999999999
col program for a45
col module for a35
select sid,serial#,event,sql_id,s.final_blocking_session,module,program from v$session S where status='ACTIVE' and type='USER';
set lines 180 pages 9999
col event for a50
col sql_id for a20
col final_blocking_session for 9999999999999
col program for a30
col module for a20
select sid,serial#,event,sql_id,s.final_blocking_session,module,program from v$session S where status='ACTIVE' and type='USER';
赞(0) 打赏
未经允许不得转载:徐万新之路 » 缓解焦虑v$session

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫

微信扫一扫

登录

找回密码

注册