DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: V$session table - column meaning

Hybrid View

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    V$session table - column meaning

    in v$sesison table there are two columns

    logon_time - date
    last_call_et number

    i am not getting what is the meaning of the column last_call_et , is this in minutes, seconds ?

    SQL > select login_time , et_number from v$session.

    --------- ------------
    19-NOV-04 216
    19-NOV-04 223
    19-NOV-04 3752
    19-NOV-04 3752
    19-NOV-04 3753
    19-NOV-04 3753
    19-NOV-04 1518
    19-NOV-04 1540
    19-NOV-04 14138
    19-NOV-04 2945
    19-NOV-04 1518

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Seconds.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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