STATSPACK與AWR的相同點與區別

- 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