V$SYSTEM_EVENT

Oracle 9iR2

SQL> desc v$system_event;
 Name                                                              Null?    Type
 ----------------------------------------------------------------- -------- --------------------------------------------
 EVENT                                                                      VARCHAR2(64)
 TOTAL_WAITS                                                                NUMBER
 TOTAL_TIMEOUTS                                                             NUMBER
 TIME_WAITED                                                                NUMBER
 AVERAGE_WAIT                                                               NUMBER
 TIME_WAITED_MICRO                                                          NUMBER

Oracle 10gR2

SQL> desc v$system_event;
 Name                                                              Null?    Type
 ----------------------------------------------------------------- -------- --------------------------------------------
 EVENT                                                                      VARCHAR2(64)
 TOTAL_WAITS                                                                NUMBER
 TOTAL_TIMEOUTS                                                             NUMBER
 TIME_WAITED                                                                NUMBER
 AVERAGE_WAIT                                                               NUMBER
 TIME_WAITED_MICRO                                                          NUMBER
 EVENT_ID                                                                   NUMBER
 WAIT_CLASS_ID                                                              NUMBER
 WAIT_CLASS#                                                                NUMBER
 WAIT_CLASS                                                                 VARCHAR2(64)
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License