Quick Question!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Quick Question!!!

  1. #1
    Join Date
    Aug 2000
    Posts
    87
    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.

  2. #2
    Join Date
    Jun 2000
    Posts
    104
    try to do auditing.check with sys.aud$ table.

  3. #3
    Join Date
    Nov 2000
    Posts
    344

    Lightbulb

    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.

  4. #4
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    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
  •  


Click Here to Expand Forum to Full Width