viewList

참고

	View Name	설명
1	V_$EVENT_NAME	OWI를 읽는 방법 제공
2	V_$SYSTEM_EVENT	This view contains information on total waits for an event. Note that the TIME_WAITED and AVERAGE_WAIT columns will contain a value of zero on those platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, you must set TIMED_STATISTICS to TRUE in the parameter file; doing this will have a small negative effect on system performance.
3	V_$SESSION_EVENT	This view lists information on waits for an event by a session. Note that the TIME_WAITED and AVERAGE_WAIT columns will contain a value of zero on those platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, you must set TIMED_STATISTICS to true in the parameter file. Please remember that doing this will have a small negative effect on system performance.
4	V_$SERVICE_EVENT	displays aggregated wait counts and wait times for each wait statistic.
5	V_$SESSION_WAIT	V$SESSION_WAIT displays the resources or events for which active sessions are waiting. The following are tuning considerations: P1RAW, P2RAW, and P3RAW display the same values as the P1, P2, and P3 columns, except that the numbers are displayed in hexadecimal. The WAIT_TIME column contains a value of -2 on platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, then you must set the TIMED_STATISTICS initialization parameter to true. Remember that doing this has a small negative effect on system performance. In previous releases, the WAIT_TIME column contained an arbitrarily large value instead of a negative value to indicate the platform did not have a fast timing mechanism. The STATE column interprets the value of WAIT_TIME and describes the state of the current or most recent wait.
6	V_$SYSTEM_WAIT_CLASS	displays the instance-wide time totals for each registered wait class.
7	V_$SESSION_WAIT_CLASS	displays the time spent in various wait event operations on a per-session basis.
8	V_$SERVICE_WAIT_CLASS	displays aggregated wait counts and wait times for each wait statistic. An aggregation of these wait classes is used when thresholds are imported.
9	V_$EVENT_HISTOGRAM	V$EVENT_HISTOGRAM displays a histogram of the number of waits, the maximum wait, and total wait time on an event basis. The histogram has buckets of time intervals from < 1 ms, < 2 ms, < 4 ms, < 8 ms, ... < 2^21 ms, < 2^22 ms, = 2^22 ms. The histogram will not be filled unless the TIMED_STATISTICS initialization parameter is set to true.     교재 : 4-11
10	V_$SESSION_WAIT_HISTORY	displays the last 10 wait events for each active session.

_EVENT를 읽기 위해 _CLASS 필요하고 _CLASS 읽기 위해 V_$EVENT_NAME이 필요하다.