Hi,
Is Statspack still available in 10g/11g? I heard it was renamed to WISE:o
Can you please give me the doc link on how to install it.
Thanks
Printable View
Hi,
Is Statspack still available in 10g/11g? I heard it was renamed to WISE:o
Can you please give me the doc link on how to install it.
Thanks
statspack is still there, in 10g and 11g there is something called AWR, WISE is a crappy product from another company
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
Thank davey and gupo :)
They said AWR is with a license fee in order to view it:confused:
Thanks
yes it is
I still prefer the free one:o do you think people will buy license for AWR:rolleyes:
if they wan tto use it they will have to buy a license