ITPub博客

首页 > Linux操作系统 > Linux操作系统 > STATSPACK与AWR的相同点与区别

STATSPACK与AWR的相同点与区别

原创 Linux操作系统 作者:yexichang 时间:2009-04-06 20:54:16 0 删除 编辑
昨天看到有人问来着,找到了份比较全的文档,大家共享下

  - 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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Chanel [Kamus]
请登录后发表评论 登录
全部评论

注册时间:2008-08-30

  • 博文量
    32
  • 访问量
    35689