The meaning of p1, p2, p3 corresponding to the waiting event

The meanings of p1, p2, and p3 corresponding to different waiting events in Oracle 10g v$session view are also different. It is impossible for us to remember the meanings of p1, p2, and p3 corresponding to all waiting events.

You can know the meaning of p1, p2, p3 corresponding to each waiting event by querying V$EVENT_NAME

 

SQL> col name for a25;
SQL> col p1 for a10;
SQL> col p2 for a10;
SQL> col p3 for a10;

 

SQL> SELECT NAME, PARAMETER1 P1, PARAMETER2 P2, PARAMETER3 P3
  2    FROM V$EVENT_NAME
  3   WHERE NAME = '&event_name';

Enter the value of event_name: db file scattered read
original value 3: WHERE NAME = '&event_name'
new value 3: WHERE NAME = 'db file scattered read'

NAME                             P1         P2            P3
----------------------------  ---------- ----------   ----------
db file scattered read       file#      block#     blocks

file#: data file number
block#: starting data block number
blocks: the number of read data blocks