| Query to select users connected [message #162239] |
Thu, 09 March 2006 05:49  |
MoleyHarey
Messages: 1
Registered: March 2006
Location: la mi
|
Junior Member |
|
|
Hi,
I am using an Oracle 9i database and I would like to know the list of users connected and number of connections open.
Is there a way to perform an SQL query to check this?
Thanks,
Mh
|
|
|
|
| Re: Query to select users connected [message #162245 is a reply to message #162239] |
Thu, 09 March 2006 06:13  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You have all information in v$session.
For the other BG process involved, join v$session with v$process.
Edit:
Are you looking for something like this?
names are masked.
oracle@mutation#dbwho widw
INST_ID USERNAME SID SPID STATUS LOGON_TIM MACHINE PROGRAM
------- --------------- ---- ------ -------- --------- -------------------- ------------------------------------------------
1 xxxxxxx 17 15338 INACTIVE 09-FEB-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 29 9010 INACTIVE 02-FEB-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 23 26116 ACTIVE 09-MAR-06 mutation sqlplus@mutation.XXXXXXX (TNS V1-V3)
1 xxxxxxx 30 12463 INACTIVE 02-MAR-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 13 21260 INACTIVE 06-MAR-06 HOST2 oracle@HOST2 (TNS V1-V3)
1 xxxxxxx 18 26091 ACTIVE 09-MAR-06 HOST3 oracle@HOST3 (P003)
1 xxxxxxx 15 26093 ACTIVE 09-MAR-06 HOST3 oracle@HOST3 (P004)
1 xxxxxxx 16 22636 ACTIVE 09-MAR-06 HOST3 sqlplus@HOST3 (TNS V1-V3)
1 xxxxxxx 21 26085 ACTIVE 09-MAR-06 HOST3 oracle@HOST3 (P000)
1 xxxxxxx 20 26087 ACTIVE 09-MAR-06 HOST3 oracle@HOST3 (P001)
1 xxxxxxx 12 8726 INACTIVE 07-MAR-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 19 3998 INACTIVE 27-FEB-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 27 16433 INACTIVE 03-MAR-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 22 7916 INACTIVE 02-MAR-06 HOST1 ? @HOST1 (TNS V1-V3)
1 xxxxxxx 24 13705 INACTIVE 20-JAN-06 HOST1 ? @HOST1 (TNS V1-V3)
1 1 22816 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (PMON)
1 2 22818 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (DIAG)
1 3 22820 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (LMON)
1 4 22822 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (LMD0)
1 5 22824 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (DBW0)
1 6 22826 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (LGWR)
1 7 22828 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (CKPT)
1 8 22830 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (SMON)
1 9 22832 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (RECO)
1 10 22834 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (CJQ0)
1 11 22836 ACTIVE 17-JAN-06 HOST3 oracle@HOST3 (QMN0)
[Updated on: Thu, 09 March 2006 06:20] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
