昨天看到有人问来着,找到了份比较全的文档,大家共享下
- AWR・STATSPACK都有的项目
Cache Sizes(end)
Load Profile
Instance Efficiency Percentages
Shared Pool Statistics
Top 5 Timed Events
Wait Events
Background Wait Events
Time Model Statistics (STATSPACK里叫Time Model System Stats)
Operating System Statistics (STATSPACK里叫OS Statistics)
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity
Tablespace IO Stats
File IO Stats
Buffer Pool Statistics
Instance Recovery Stats
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
Java Pool Advisory
Buffer Wait Statistics
Enqueue Activity
Undo Segment Summary
Undo Segment Stats
Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics
Segments by Logical Reads
Segments by Physical Reads
Segments by Buffer Busy Waits
Segments by Row Lock Waits
Segments by ITL Waits
Dictionary Cache Stats
Library Cache Activity
SGA Memory Summary
SGA breakdown difference
init.ora Parameters
RAC相关统计信息:
RAC Report Summary(STATSPACK里叫RAC Statistics)
Global Cache Load Profile
Global Cache Efficiency Percentages
Global Cache and Enqueue Services - Workload Characteristics
Global Cache and Enqueue Services - Messaging Statistics
Global Enqueue Statistics(STATSPACK里叫Global Enqueue Stats)
Global CR Served Stats
Global CURRENT Served Stats
Global Cache Transfer Stats
Segments by CR Blocks Received
Segments by Current Blocks Received
- 只有AWR才有的项目
Service Statistics
Service Wait Class Stats
SQL ordered by Elapsed Time
SQL ordered by CPU Time
Resource Limit Stats
RAC相关统计信息:
Dictionary Cache Stats (RAC)
Library Cache Activity (RAC)
- 只有STATSPACK才有的项目
Wait Event Histogram (*2)
File Read Histogram Stats
Rollback Segment Stats
Rollback Segmetn Storage
RAC相关统计信息:
SQL ordered by Cluster Wait Time (*3)
RAC相关统计信息:[使用了STREAMS]:(*3)
Streams Capture
Propagation Sender
Propagation Receiver
Streams Apply
Buffered Queues
Buffered Queue Subscribers(AWR里叫Buffered Subscribers)
Rule SetsK
[ 本帖最后由 yexichang 于 2009-4-6 20:53 编辑 ]
- AWR・STATSPACK都有的项目
Cache Sizes(end)
Load Profile
Instance Efficiency Percentages
Shared Pool Statistics
Top 5 Timed Events
Wait Events
Background Wait Events
Time Model Statistics (STATSPACK里叫Time Model System Stats)
Operating System Statistics (STATSPACK里叫OS Statistics)
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity
Tablespace IO Stats
File IO Stats
Buffer Pool Statistics
Instance Recovery Stats
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
Java Pool Advisory
Buffer Wait Statistics
Enqueue Activity
Undo Segment Summary
Undo Segment Stats
Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics
Segments by Logical Reads
Segments by Physical Reads
Segments by Buffer Busy Waits
Segments by Row Lock Waits
Segments by ITL Waits
Dictionary Cache Stats
Library Cache Activity
SGA Memory Summary
SGA breakdown difference
init.ora Parameters
RAC相关统计信息:
RAC Report Summary(STATSPACK里叫RAC Statistics)
Global Cache Load Profile
Global Cache Efficiency Percentages
Global Cache and Enqueue Services - Workload Characteristics
Global Cache and Enqueue Services - Messaging Statistics
Global Enqueue Statistics(STATSPACK里叫Global Enqueue Stats)
Global CR Served Stats
Global CURRENT Served Stats
Global Cache Transfer Stats
Segments by CR Blocks Received
Segments by Current Blocks Received
- 只有AWR才有的项目
Service Statistics
Service Wait Class Stats
SQL ordered by Elapsed Time
SQL ordered by CPU Time
Resource Limit Stats
RAC相关统计信息:
Dictionary Cache Stats (RAC)
Library Cache Activity (RAC)
- 只有STATSPACK才有的项目
Wait Event Histogram (*2)
File Read Histogram Stats
Rollback Segment Stats
Rollback Segmetn Storage
RAC相关统计信息:
SQL ordered by Cluster Wait Time (*3)
RAC相关统计信息:[使用了STREAMS]:(*3)
Streams Capture
Propagation Sender
Propagation Receiver
Streams Apply
Buffered Queues
Buffered Queue Subscribers(AWR里叫Buffered Subscribers)
Rule SetsK
[ 本帖最后由 yexichang 于 2009-4-6 20:53 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/317003/viewspace-584886/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/317003/viewspace-584886/