V$session Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V$session Help

  1. #1
    Join Date
    May 2001
    Posts
    25

    Red face

    Dear Friends..

    I am checking thorugh V$session, that which user is connecting with our application, but i am unable to check which SQL command that particular user is using.

    Can anybody will advise, how can we check it.

    Thanks in advance.

    Sandeep

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    just make a join between v$session.sql_address and v$sqlarea.address, and get sql_text
    from v$sqlarea

  3. #3
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    rem Name: Xsqluser.sql - SQLText executing now per user
    rem Date: 08-may-2001
    rem Note: Select is on "users_executing >0" ; only active statements.

    set pages 100 feed OFF wrap on linesize 100
    col SID for 999
    col buffer_gets for 99999999999 head 'Buffer|reads'
    col users_executing for 999 head 'Exec|now'
    col executions for 999999 head 'Execs'
    col rows_processed for 999999 head 'rows|procesd'
    col firstload head 'First|load'
    col username for A10 head Username word_wrap
    col sql_text for A40

    select S.SID
    ,S.username
    ,A.users_executing
    ,A.buffer_gets
    ,A.executions
    ,A.rows_processed
    ,substr(A.first_load_time,12,8) Firstload
    ,A.sql_text
    from v$SQLAREA A
    ,v$SESSION S
    where A.address = S.sql_address
    and S.username = &username
    order by users_executing,first_load_time
    /
    J.Jongman - DBA

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