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

Thread: Staspack in 10g

  1. #1
    Join Date
    Oct 2007
    Posts
    114

    Staspack in 10g

    Hi,

    Is Statspack still available in 10g/11g? I heard it was renamed to WISE
    Can you please give me the doc link on how to install it.


    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    statspack is still there, in 10g and 11g there is something called AWR, WISE is a crappy product from another company

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Oracle8i introduced the Statspack functionality which Oracle9i extended. In Oracle 10g statspack has evolved into the Automatic Workload Repository (AWR).
    Workload Repository Reports
    Oracle provide two scripts to produce workload repository reports (awrrpt.sql and awrrpti.sql). They are similar in format to the statspack reports and give the option of HTML or plain text format

  4. #4
    Join Date
    Oct 2007
    Posts
    114
    Thank davey and gupo

    They said AWR is with a license fee in order to view it


    Thanks

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes it is

  6. #6
    Join Date
    Oct 2007
    Posts
    114
    I still prefer the free one do you think people will buy license for AWR

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if they wan tto use it they will have to buy a license

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