01001010111

2009년 07월 17일

Metrics

근데
묘하게
안맞는다.

12시 20분과 25분
사이에
단
하나의
상승선이
있어야
하는데

Query로
보면 2개가 20분과 22분
사이에
나온다.

나만
그런게
아니었다는;;;

참고로
저
값은 wait_count값임.

# by 01001010111 | 2009/07/17 01:21 | 트랙백 | 덧글(0)

2009년 07월 16일

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.

See Also:

"TIMED_STATISTICS"

Column	Datatype	Description
SID	NUMBER	ID of the session
EVENT	VARCHAR2(64)	Name of the wait event See Also: Appendix C, "Oracle Wait Events"
TOTAL_WAITS	NUMBER	Total number of waits for the event by the session
TOTAL_TIMEOUTS	NUMBER	Total number of timeouts for the event by the session
TIME_WAITED	NUMBER	Total amount of time waited for the event by the session (in hundredths of a second)
AVERAGE_WAIT	NUMBER	Average amount of time waited for the event by the session (in hundredths of a second)
MAX_WAIT	NUMBER	Maximum time waited for the event by the session (in hundredths of a second)
TIME_WAITED_MICRO	NUMBER	Total amount of time waited for the event by the session (in microseconds)
EVENT_ID	NUMBER	Identifier of the wait event
WAIT_CLASS_ID	NUMBER	Identifier of the class of the wait event
WAIT_CLASS#	NUMBER	Number of the class of the wait event
WAIT_CLASS	VARCHAR2(64)	Name of the class of the wait event

Pasted from <http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2091.htm#sthref2735>

col event form a40;

select * from (

select sid,event ,total_waits,wait_class

from v$session_event S

where (select username from v$session where sid=s.sid) is not null

and sid not in(

select sid from v$session

where username in('SYSMAN','DBSNMP','SYS')

)

order by total_waits desc

)

where rownum<10

# by 01001010111 | 2009/07/16 01:22 | 트랙백 | 덧글(0)

2009년 07월 16일

V_$SERVICE_STATS

V$SERVICE_STATS

V$SERVICE_STATS displays a minimal set of performance statistics. These call rate statistics are used for making run-time routing decisions, for tracking service levels, and for per-instance diagnostics per call rate. The elapsed timing for each call provides a relative value across instances for how well a node is processing SQL calls issued under a service name.

When aggregation is enabled for the Service Name, then this view provides the timing and work done for calls issued for the whole service.

Column	Datatype	Description
SERVICE_NAME_HASH	NUMBER	Service name hash from V$SERVICES
SERVICE_NAME	VARCHAR2(64)	Service name from V$SERVICES
STAT_ID	NUMBER	Statistic identifier
STAT_NAME	VARCHAR2(64)	Derived statistic name from V$STATNAME and V$SESS_TIME_MODEL
VALUE	NUMBER	Cumulative value (in microseconds)