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!

How to convert between p1 and p1raw in v$session_wait?

649748Jul 31 2009 — edited Aug 1 2009

We have a tool about v$session_wait which only shows p1 instead of p1raw. For some wait such as latch free, I need to know the p1raw. But how to convert between p1 and p1raw?

example from v$session_wait:
p1 675562835
p1raw 28444553

I tried to use rawtohex(p1raw)=rawtohex(28444553)=3238343434353533 which has nothing to do with the real p1. Any one has any idea?

Thanks,
Daniel

This post has been answered by sb92075 on Aug 1 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2009

Added on Jul 31 2009

#general-database-discussions

3 comments

2,418 views