Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    7

    Unanswered: user information

    Kindly tell how I can know which user are connected to my database and still connected their duration of connection and exactly which changes they have made to the database.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Kindly tell how I can know which user are connected to my database and still connected their duration of connection
    query V$SESSION

    > and exactly which changes they have made to the database.
    With much difficulty or not at all.
    It is very much application dependent.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    Kindly tell how I can know which user are connected to my database and still connected their duration of connection

    -> query on V$SESSION

    and exactly which changes they have made to the database.

    -> for this you need to enable oracle audit feature
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    This will tell you the last activity and length of login time by user and the executable they are running


    --
    --Monitor Session Idle Time
    --
    set linesize 100
    col sid format 999
    col username format a10 truncated
    col status format a1 truncated
    col logon format a17
    col idle format a9
    col program format a30 truncated
    col machine format a20 truncated

    select
    sid,username,status,
    to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON",
    floor(last_call_et/3600)||':'||
    floor(mod(last_call_et,3600)/60)||':'||
    mod(mod(last_call_et,3600),60) "IDLE",
    program,
    machine
    from
    v$session
    where
    type='USER'
    order by last_call_et;

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •