Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: Connect Time for user

    I need to use Sql to query Oracle to find out some of the attributes (e.g. Connect_Time ) associated with a oracle user.

    But i can't seems to find any help on the internet .
    Pls help. Thanks.

  2. #2
    Join Date
    Jul 2004
    Posts
    102
    If you want to see the user LOGON Time use

    select username,to_char(LOGON_TIME,'dd-mm-yy HH:MIS') from v$session

    Think this will help you.
    Working Together...

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Here's a little script I use to look at inactive time ...
    It shows how long users have been inactive ,,,

    --
    --Monitor Session Idle Time
    --
    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

    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
    from
    v$session
    where
    type='USER'
    order by last_call_et;

    HTH
    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
  •