Pages

Tuesday, March 15, 2011

Session blocking quiesce


Create Or Replace Force View Sys.Av_db_sess_blking_quiesc (Sid,
                                                           Sess_user,
                                                           Osuser,
                                                           Type,
                                                           Program,
                                                           Killstmt
                                                          )
As
   Select Bl.Sid, User Sess_user, Osuser, Type, Program,
             'Alter SYSTEM DISCONNECT Session '
          || ''''
          || Se.Sid
          || ','
          || Se.Serial#
          || ''' '
          || 'IMMEDIATE;' Killstmt
     From V$blocking_quiesce Bl, V$session Se
    Where Bl.Sid = Se.Sid;

No comments:

Post a Comment