rogue sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: rogue sessions

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    ver 7.2.2

    Hi Friends

    I have an ancient database whih has about 7 sessions in there which aren't user sessions.
    They have sids and serial#'s as follows :

    sid serial#
    1 1
    2 1
    3 1
    4 1
    5 1
    6 1
    7 1

    when I try an kill any of these sessions I get an error explaining that they are not user sessions

    Does anyone know what type of sessions they could be ?

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi..

    also realised that these sessions appear in oracle 8 databases aswell. Do these sessions belong to the oracle background processes?

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    These are Oracle processes, for example, PMON, SMON, DBWR, etc.

    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    Apr 2001
    Posts
    107
    hi,
    If you look at the owner of thes processes, you should see 'SYS'.
    They are oracle internal processes...

    Cheers

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks Folks
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    If you don't want to include the SID's of
    background process just include in the WHERE statement:
    select sid,.....
    from v$session
    WHERE username is not null;

    Keep it cool.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    sometimes you may have to use

    select *
    from v$session
    where type <> 'BACKGROUND'

  8. #8
    Join Date
    Oct 2000
    Posts
    467
    check for type = 'BACKGROUND' from the v$session. this will list u all the background processes. Hope that helps.

    cheers,
    Vinit

Posting Permissions

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



Click Here to Expand Forum to Full Width