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

Thread: sp_who

  1. #1
    Join Date
    Nov 2002
    Location
    London, UK
    Posts
    13

    sp_who

    Hello there,

    I am looking for an equivalent command of "sp_who" in ORACLE 8. I use sp_who in SQLSERVER/SYBASE to see all the logged in user.

    Cheers

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    select username from v$session
    where sid > 6;

    (The sid > 6 is so you will see actual users, not Oracle processes)

  3. #3
    Join Date
    Nov 2002
    Location
    London, UK
    Posts
    13
    cheers Steve.

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