OraFAQ Forum: SQL & PL/SQL » out number of users connected to the database

Home » SQL & PL/SQL » SQL & PL/SQL » out number of users connected to the database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

out number of users connected to the database [message #22547]

Wed, 16 October 2002 23:43

R.SIVAKUMAR
Messages: 48
Registered: February 2002

Member

how to find out number of users connected to the database in particular time or date ?

siva

Report message to a moderator

Re: out number of users connected to the database [message #22553 is a reply to message #22547]

Thu, 17 October 2002 01:26

siva
Messages: 58
Registered: August 1999

Member

I think this query will give the info u need
select "USERNAME","STATUS","SCHEMANAME","OSUSER","MACHINE","TERMINAL",
"LOGON_TIME" from v$session

Hope this helps !!

Report message to a moderator

find out the disconnected time [message #22555 is a reply to message #22547]

Thu, 17 October 2002 03:21

R.SIVAKUMAR
Messages: 48
Registered: February 2002

Member

thanx siva,

how can find out the disconnected time of the particular user ?

siva

Report message to a moderator

Re: find out the disconnected time [message #22625 is a reply to message #22555]

Sat, 19 October 2002 13:05

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hi,,
to find out the logoff time..i would opt for writing a database level trigger on the event logoff and dump the info into a user defined table.

Bye
sai

Report message to a moderator

Previous Topic:	Extract month & year value from date field
Next Topic:	Order by special case

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 08:22:33 CDT 2024