_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 襴觀
Describe 襴觀 here

===============
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;



蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

語 ろ 覈 讌襷 蠏瑚 願屋 蟆 訖企. (ろ)