缓解焦虑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';