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

Thread: Quick Question!!!

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

    Vinod Kumar.

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

  3. #3
    Join Date
    Nov 2000


    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
    Elbert, Colorado, USA
    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