Results 1 to 4 of 4

Thread: v$session

  1. #1
    Join Date
    Sep 2003
    Location
    USA/PA
    Posts
    6

    Unanswered: v$session

    Hi all,

    Are the v$session analgous to the unix processes i.e. if I execute the following sql
    select count(*),username from v$session group by username
    should the total equal the amount of oracle processes that are running on my solaris box?


    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    CA
    Posts
    38

    Re: v$session

    No, it isn't the total processes I believe its the no. of different points from where u login into the database.
    Pooja
    Originally posted by roliver
    Hi all,

    Are the v$session analgous to the unix processes i.e. if I execute the following sql
    select count(*),username from v$session group by username
    should the total equal the amount of oracle processes that are running on my solaris box?


    Thanks

  3. #3
    Join Date
    Sep 2003
    Location
    kerala
    Posts
    24

    Re: v$session

    v$session gives information about differnt sessions that started sincde the startup of oracle database
    if u want to know the count of disfferent process starteed by the user
    u can join v$process with v$session
    with sid as the commo field
    regards
    praveen

  4. #4
    Join Date
    Sep 2003
    Location
    USA/PA
    Posts
    6

    Re: v$session

    Thanks praveen, This info is a big help

    Originally posted by praveenagri
    v$session gives information about differnt sessions that started sincde the startup of oracle database
    if u want to know the count of disfferent process starteed by the user
    u can join v$process with v$session
    with sid as the commo field
    regards
    praveen

Posting Permissions

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