Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Confusion in column of V$session_wait

845641May 3 2012 — edited May 4 2012

Hi experts, please explain me the meaning of p1,p2,p3 columns i am confused, i know this wait event but i am not able to interpret what p1,p2,p3 value means here

SQL> select event,seconds_in_wait,p1,p2,p3 from v$session_wait where sid=34

EVENT SECONDS_IN_WAIT P1 P2 P3
---------------------------------------------------------------- -----------------------------------
enq: TX - row lock contention 52 1415053318 458757 989

Edited by: 842638 on May 3, 2012 8:24 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2012

Added on May 3 2012

#general-database-discussions

8 comments

2,557 views