文章

    UpDown选择

    登陆后,即可购买哦!





    select /*+ rule*/  a.sid, a.serial#,
           a.paddr, 'alter system kill session ''' || a.sid || ',' || a.serial# || ''';' AS kill_session,b.OBJECT
    FROM v$session a, v$access b
    WHERE a.sid = b.sid
    AND b.OBJECT = UPPER('pkg_wx_sm');


    alter system kill session '1,5';
    alter system kill session '28,803';
    alter system kill session '34,713';
    alter system kill session '43,1023';
    alter system kill session '58,962';
    alter system kill session '243,1626';
    alter system kill session '90,582';
    alter system kill session '114,205';
    alter system kill session '139,752';
    alter system kill session '194,2682';
    alter system kill session '84,857';
    alter system kill session '234,2585';