v$session_wait and its meaning ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: v$session_wait and its meaning ...

  1. #1
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97

    Question v$session_wait and its meaning ...

    Hallo,

    IŽam preparing my tuning exame. There is a problem I can not solve:

    1. User brain is updating one row of a table and did not commit.
    2. User pinky is trying to update the same row in that table.
    3. This situation generates an "enqueue" event, I can find with the help of v$system_event, v$session_event and v$session_wait.
    4. v$sesion_event in combination with v$session tells me the user who is waiting.
    5. Now I want to find out, for what pinky is waiting. Is it possible with v$session_wait? What are the collums (P1, P2, ....) mean?

    Can somebody help me?

    Thank you,

    Christian

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you cannot know what rows is locked

    rest read tahiti.oracle.com

  3. #3
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    but can I know, which user is locking the table? So I can tell him to commit? :-)

    Christian

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    yes, look v$lock but not v$session_wait

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