DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How To kill a Session

  1. 01-06-2001, 10:18 AM #1
    Subr
    Subr is offline Junior Member
    Join Date
    Jan 2001
    Posts
    1

    Thumbs down

    How To kill a Session
    Reply With Quote Reply With Quote
  2. 01-06-2001, 11:06 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Its dba command

    SQL> SELECT sid,serail# from v$session;

    ALTER SYSTEM kill session (sid,serial#);



    Reply With Quote Reply With Quote
  3. 01-08-2001, 06:09 AM #3
    satnut
    satnut is offline Junior Member
    Join Date
    Dec 2000
    Posts
    4
    SELECT sid, serial#
    FROM v$session
    WHERE username = ‘user name’;

    SID SERIAL#
    ------- ----------
    34 3948

    ALTER SYSTEM
    KILL SESSION ‘34,3948’;

    With regards
    SATYA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width