在以下视图中都有P1,P2,P3参数
select * from v$session select * from v$session_wait select * from v$session_wait_history
可从V$EVENT_NAME视图中得到具体参数的含义:
举例:
SQL> col name for a30
SQL> col p1 for a20
SQL> col p2 for a20
SQL> col p3 for a20
SQL> SELECT NAME, PARAMETER1 P1, PARAMETER2 P2, PARAMETER3 P3 FROM V$EVENT_NAME WHERE NAME = 'db file scattered read';
NAME P1 P2 P3
db file scattered read file# block# blocks
详细说明请参考官档:Oracle Database Performance Tuning Guide