Oracle dynamic performance view v $ event_name V $ EVENT_NAME view lists a set of waiting events. It provides information about sessions that must be processed:
For official documents on www.2cto.com, see V $ EVENT_NAMEV $ EVENT_NAME displays information about wait events. column Datatype DescriptionEVENT # NUMBER Number of the wait eventEVENT_ID NUMBER Identifier of the wait eventNAME VARCHAR2 (64) Name of the wait eventPARAMETER1 VARCHAR2 (64) description of the first parameter for the wait eventPARAMETER2 VARCHAR2 (64) Description of the second parameter for the wait eventPARAMETER3 VAR CHAR2 (64) Description of the third parameter for the wait eventWAIT_CLASS_ID NUMBER Identifier of the class of the wait eventWAIT_CLASS # NUMBER Number NUMBER of the class of the wait eventWAIT_CLASS VARCHAR2 (64) name of the class of the wait eventSee Also: "Classes of Wait Events" for a description of the different wait event classes column Name explanation www.2cto.com EVENT # event no. EVENT_ID event idname event Name PARAMETER1, PARAMETER2, PARAMETER3: three parameters related to the wait event WAIT_CLASS_ID: IDWAIT_CLASS of the wait event # class ID of the wait event WAIT_CLASS example of the wait event type 1SQL> select name, parameter1, parameter2, parameter3, wait_class #, wait_class, wait_class_id from v $ event_name where name = 'buffer busy waits '; NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS # WAIT_CLASS WAIT_CLASS_ID ---------------- wait_class passed ------------------------------------------------------------------------------------------------ --------------- ------------- Buffer busy waits file # block # class #4 Concurrency 3875070507 buffer busy waits buffer busy wait events wait until one buffer zone becomes available. This event occurs in either of the following two situations where the buffer zone is being used by another session read buffer high-speed cache, the session is waiting for the read to complete, or the buffer is in the buffer cache but is in incompatible mode, that is, when another session is modifying the buffer, this event is completed, there are three parameters: file # Waiting file number block # Waiting file number class # Waiting type number buffer busy waits waiting type is concurrency (waiting for database resources ), class number is 4 (different versions may be different), Class ID is 3875070507 Example 2 www.2cto.com SQL> select name, parameter1, para Meter2, parameter3, wait_class #, wait_class, wait_class_id from v $ event_name where name like '% log file switch % '; NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS # WAIT_CLASS WAIT_CLASS_ID certificate ---------------------- ------------------ -------------------- --------- certificate ------------- log file switch (checkpoint incomplete) 2 Configuration 3290255840log file switch (checkpoint incomplete) log file switch wait (checkpoint unfinished) Wait for a log switch because the session cannot be switched to the next log and cannot be switched, the check point of the log is not completed yet. This event has no parameters