-
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.
-
try to do auditing.check with sys.aud$ table.
-
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.
-
jdorlon -
Excellent solution, but (as you suspected) those triggers are an 8.1 feature, not 8.0.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|