`
- 浏览:
1315143 次
-
Diagnostic and Tuning Tools(3)
statspack报告,对数据库做一次全面的体检。
参考书:《Oracle database 10g performance tuning tips & techniques 》
《Your Performing toolkit》 TOM大师
DD and Special Views
dba_tables,dba_tab_columns
dba_clusters
dba_indexes,index_stats
index_histogram,dba_tab_histograms
This statistical information is static until you reexecute dbms_stats.
重新执行一次这个包,这些信息才会改变。
Systemwide Statistics全局性的信息
v$sysstat,v$sgastat,v$event_name,v$system_event
Session-Related Statistics会话级别的信息
v$statname,v$sesstat,v$session
v$session_event,v$event_name,v$session_wait;
实验:
conn hr/hr
select sid,serial#,username from v$session
desc v$sesstat
select * from v$sesstat where sid=12;
统计指标是164,VALUE是6,什么含义呢?就查询v$statname了。
Oracle Wait Events
等待资源。
v$event_name
v$session_event:Waits for an event for each session that had to wait.
v$session_wait:Waits for an event for current active sessions that are waiting.
v$system_event:Total waits for an event,all sessions together.
分享到:
Global site tag (gtag.js) - Google Analytics
相关推荐
The book sequence is easy to follow and all topics are fully illustrated showing you how to make good use of different performance diagnostic tools. Who this book is written for If you are an ...
Debug Diagnostic Tools生成内存分析文件
Chapter 2 and Chapter 3 are relatively longer and describe the fundamental physics involved and a crucial device in ultrasound, ultrasonic transducers. Conventional imaging approaches and Doppler ...
This application gives an introduction...presents the basic technical aspects and possibilities with the Diagnostic Feature Set, complements the help file of CANoe/CANalyzer and may be used as a tutorial
下载下来在客户端执行一下可以检测你客户端计算机连接WSUS的状态, 测试连接的过程zd中如果有错误会有红色的字符提醒。
AN-IND-1-001_CANoe_CANalyzer_as_Diagnostic_Tools
新增 Wonders语言水平测试工具 Wonders Placement and Diagnostic Assessment.pdf
Diagnostic Tool是一款简单好用的打印机设置工具,该软件是专门针对TSC型号的条码打印机精心设计的,目前分为四种功能分别是打印机设定、档案管理、点阵字工具、通讯工具,在这四项功能中,最实用的功能是打印机设定...
IMMUNOPROTECTION AND DIAGNOSTIC POTENTIAL OF SIGNALING PROTEIN 14-3-3 OF SCHISTOSOMA JAPONICUM×,刘庆中,沈继龙,The 14-3-3 protein is a key player in signal transduction processes in various species...
Glycosyltransferase-related prognostic and diagnostic biomarkers of uterine corpus endometrial carcinoma 文章补充代码学习
School phobia and separation anxiety: Diagnostic and treatment comparisons 384 Klingman NOY, B. (1991). OMER, H. (1991). RAVIV, A. (in press). Pupils’calls to the Open Line during the ...
台湾TSC公司的调试软件,有助于熟悉和使用条码机。
Using the LND tool to analyze IBM Lotus Notes and Domino hangs and crashes http://www-10.lotus.com/ldd/dominowiki.nsf/dx/Using_the_LND_tool_to_analyze_IBM_Lotus_Notes_and_Domino_hangs_and_crashes
大众汽车售后ODIS诊断仪 4.2版本 说明 英文原版 版本日期28-Oct-2017 23:55
Debug Diagnostic Tool v2 Update 3.1.zip
关于UDS诊断的介绍,非常清晰易懂,不过是日文的。
This book tells you about the way the...debugging techniques, and the diagnostic tools that are available to help you sol problems with Java VMs. It also gives guidance on how to submit problems to IBM.
Interclinician agreement and bias in school psychologists' diagnostic and treatment recommendations for a learning disabled child Psychology in rhe Schools 1982, 19, 319-327 INTERCLINICIAN ...
Diagnostic Captioning A Survey.pdf