Quick Question!!!

[vinodkmg]

Hi All,
One quick question...i want to see how many users are connected at given point of time....

I know that from V$session we can get current users connected but what i wanted to know is, from morning 7 to evening 7 how many users have logged in and logged off and at what time...

we have 8.0.6 version.

Thanks
Vinod Kumar.

[drishti]

try to do auditing.check with sys.aud$ table.

[jdorlon]

with Oracle 8i, you can put triggers on database events (like users logging on and off). This might have also been available in 8.0, I am not sure. Check your 8.0 documentation under 'Create Trigger'

If 8.0 allows this kind of trigger, you can create a table and have the trigger insert logon and logoff information into it.

[carp]

jdorlon -

Excellent solution, but (as you suspected) those triggers are an 8.1 feature, not 8.0.