Monitor User Connectivity
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Monitor User Connectivity

  1. #1
    Join Date
    May 2001
    Posts
    28

    Question

    Without turning trace on, can someone recommend a way to monitor user access or activity to an Oracle database? We are worried about users performing long-running queries using columns that are not keys or indexed.

    Is there a table that has information about a particular user such as last connect time, how long connected, etc?

    Thank you.

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Try V$session

    Regards
    Santosh

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    hi,
    See without tracing on we can find out which users are executing the sql statements.
    U perform the following steps

    1) Get the sid,serial# from v$session by running the following query,
    sql > select sid,serial#,username,machine from v$session where username='&username';

    2) Run the follwing query under user sys to get the sqltext running by that user.Enter the sid and serial# which u got from the previous query.

    select sql_text from v$sqltext_with_newlines
    where (hash_value,address) in(
    select sql_hash_value,sql_address from v$session
    where sid=&sid and serial#=&Serial)
    order by address,piece


    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    May 2001
    Posts
    28

    Thumbs up Thanks!

    Just wanted to thank you all for your valuable help with my questions!!

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