Shulou(Shulou.com)06/01 Report--

In the following views, there are P1Magol, P2P3 parameters.

Select from v$session

Select from v$session_wait

Select * from v$session_wait_history

You can get the meaning of specific parameters from the V$EVENT_NAME view:

For example:

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

For more information, please refer to the official file: Oracle Database Performance Tuning Guide

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.