DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: AWR Report 10G (Statpacks)

  1. #1
    Join Date
    Nov 2005
    Posts
    10

    AWR Report 10G (Statpacks)

    Gurus,

    Would someone please provide me with the SQL that generates the following report?

    Instance Efficiency Percentages (Target 100%)

    Buffer Nowait %: 100.00 Redo NoWait %: 99.98
    Buffer Hit %: 99.96 In-memory Sort %: 100.00
    Library Hit %: 99.71 Soft Parse %: 99.15
    Execute to Parse %: 6.14 Latch Hit %: 97.52
    Parse CPU to Parse Elapsd %: 54.66 % Non-Parse CPU: 86.83

    Any help would be great!

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool



    That report is part of the stats-pack report (spreport.sql)

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width