You Asked
Hi Tom,
Want to understand what exactly P1TEXT, P1, P3TEXT, P2 denote in various v$ views like v$session, v$session_wait. Documentation says
P1TEXT : Description of the first wait event parameter
P1 : First wait event parameter (in decimal)
P2TEXT : Description of the second wait event parameter
P2 : Second wait event parameter (in decimal)
But don't quite understand how to interpret them and make use of that during troubleshooting.
and Connor said...
They are simply more detail for the particular wait we are currently on.
For example, I might be in a wait of "enqueue" (ie, waiting to get a lock). But that could be:
- waiting to lock a row
- waiting to lock a table
- waiting to lock the controlfile
- etc
So the p1,p2,p3 parameters give more information for a particular kind of event.
Take a look here
http://docs.oracle.com/database/122/REFRN/oracle-wait-events.htm#REFRN101 for the descriptions.