===============
Dictionary View
===============
- る狩 一危碁伎れ 覲企ゼ 螻牛.(瑚係襾狩碁れ 覲, 覃覈襴 )
- DBA_xxxx襯 螳讌.
- ANALYZE 覈
- 一危 レ 譟一襯 覈
- 糾 讌 DBA_xxxx 覈覈 豪 貉る殊
- 糾覲企 ANALYZE 覈轟 蟾讌 螻企.
- 企
- DBA_TABLES
- DBA_TAB_COLUMNS
- 碁煙
- DBA_INDEXES
- INDEX_STATS
- 企ろ
- DBA_CLUSTERS
- ろ蠏碁
- DBA_HISTOGRAMS
- INDEX_HISTOGRAM
- 語ろ伎 覯 觀
-語ろ伎/一危覯伎れ 蟯螻 觀
- V$WAITSTAT : 蟆渚 糾 襴ろ, TIMEED_STATISTICS螳 燕 襷 螳煙
- V$SYSTEM_EVENT : 轟 企欧語 WAIT 糾
- 覃覈襴 蟯 觀
- V$SYSSTAT
- V$SGASTAT
- V$DB_OBJECT_CACHE
- V$LIBRARYCACHE
- V$ROWCACHE : 一危 襴 語 ろ
- ろ 焔 觀
-V$FILESTAT
- 蟆渚 蟯螻 觀
- V$WAITSTAT : 觚襦 蟆渚 糾
- V$LATCH
- V$ROLLSTAT
* V$SYSSTAT 焔 觀磯 語ろ伎り 覈 ろ 糾覲企ゼ 願 .
* 焔 觀磯 X$企 蠍磯朱 螻 企 碁危碁 襷危 襷
蠏殊 螳ロ覃, 企 覲願 讌伎 .
INIT.ORA企 timeed_statistics = true襯 螳
alter system set titmed_statistics = true襯 覃 .
SQL> SELECT * FROM V$SYSSTAT;
STATISTIC# NAME CLASS VALUE
---------- ---------------------------------------------------------------- ---------- ----------
0 logons cumulative 1 758
1 logons current 1 14
2 opened cursors cumulative 1 3549
3 opened cursors current 1 14
4 user commits 1 0
5 user rollbacks 1 0
6 user calls 1 2692
7 recursive calls 1 50892
8 recursive cpu usage 1 0
9 session logical reads 1 451644
10 session stored procedure space 1 0
11 CPU used when call started 128 0
12 CPU used by this session 1 0
13 session connect time 1 0
14 process last non-idle time 128 0
15 session uga memory 1 4416168
16 session uga memory max 1 17152180
17 messages sent 128 59
18 messages received 128 59
19 background timeouts 128 1293
20 session pga memory 1 108111940
21 session pga memory max 1 108129332
22 enqueue timeouts 4 0
23 enqueue waits 4 0
24 enqueue deadlocks 4 0
25 enqueue requests 4 1185
26 enqueue conversions 4 0
27 enqueue releases 4 1176
28 global lock sync gets 32 0
. . .
. . .
- 企 る
- 1 : 朱 語ろ伎
- 2 : 襴襦蠏 覯
- 4 : 襦
- 8 : 一危覯伎 覯 貂
- 16 : 伎豌伎
- 32 : 覲
- 64 : 企 蠏
- 128 : 覯蟾
-語 覯 觀
- V$MYSTAT
- V$LOCK
- V$SESSTAT
- V$SESSION_EVENT
- V$SESSION_WAIT
SELECT USERNAME, NAME, VALUE
FROM V$STATNAME ST, V$SESSION SE, V$SESSTAT SES
WHERE SE.SID = SES.SID
AND ST.STATISTIC# = SES.STATISTIC#
AND SE.TYPE = 'USER'
AND SE.USERNAME IS NOT NULL
AND ST.NAME = 'Excute Count'
AND SES.VALUE > 50;