Session waiting -- Urgent help required
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Session waiting -- Urgent help required

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    Session waiting -- Urgent help required

    The below is the scrap of a trace when one of our user reported his session is hang.
    The status of his session is INACTIVE.

    SELECT DECODE(UPPER(:b1),'HTML','.RPT','PDF','.PDF','.RPT')
    FROM
    DUAL


    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 0 0.00 0.00 0 0 0 0
    Execute 11 0.00 0.00 0 0 0 0
    Fetch 11 0.00 0.00 0 33 0 11
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 22 0.00 0.00 0 33 0 11

    Misses in library cache during parse: 0
    Optimizer goal: CHOOSE
    Parsing user id: 509 (xyuser)

    Rows Execution Plan
    ------- ---------------------------------------------------
    0 SELECT STATEMENT GOAL: CHOOSE
    0 TABLE ACCESS (FULL) OF 'DUAL'


    Elapsed times include waiting on following events:
    Event waited on Times Max. Wait Total Waited
    ---------------------------------------- Waited ---------- ------------
    SQL*Net message to client 22 0.00 0.00
    SQL*Net message from client 21 1299.58 1499.63
    ********************************************************************************


    Entries in V$session_wait is

    SQL> select * from v$session_wait where sid=120;

    SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
    ---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ---------- --------------- -------------------
    120 2158 SQL*Net message from client driver id 675562835 0000000028444553 #bytes 1 0000000000000001 0 00 0 279 WAITING



    Refer to my previous post about the DUAL table. THe above post is same with more details. I could able to simulate the issue also.

    Please advice what could be wrong.?
    I could also take more information (as long as the user is using this module -- luckily now using).

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    dosent that wait event clearly tell you what is it waiting on?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    That user's session is hanged.

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    how can it?.. if it indeed is.. there is some problem with his OS.. or may be anything..

    Note : right click the window and say maximize..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    User said ALL OPTIONS TRIED.
    I am getting the FMB from the dev team, and do various testings, and feedback. Sorry for positing this as URGENT.

    Thanks Abhay

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