Home » RDBMS Server » Server Administration » AWR and statspack usage on Oracle 10g Database (
AWR and statspack usage on Oracle 10g Database [message #276203] Wed, 24 October 2007 06:23 Go to next message
Messages: 20
Registered: December 2005
Junior Member

When we start Oracle 10g Database, by default, a new background
process (mmon) will start which will gather all the statistics required to run AWR.

In case we don't buy AWR license, We have to use statspack to monitor our database insted of AWR.

My Question :
Does this scenario will have double impact on database to collect statistics ?
Also please verify, if my above understanding is correct or not.

Arun Tayal
Re: AWR and statspack usage on Oracle 10g Database [message #276244 is a reply to message #276203] Wed, 24 October 2007 08:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You no need to buy any additional license for AWR report.
In Oracle 10g. AWR report is used instead of STATSPACK report.
statspack report is also there you can use it.
but awr report is easy to create and easy to read in HTML format.

just run "awrrpt.sql" script for create AWR report.
Default time interval is 60 minutes but you can edit.
awrrpt.sql script located in "$oraclehome/rdbms/admin" folder.

Mohammed Taj
Previous Topic: fail to drop tablespace
Next Topic: PGA Aggregate Target File Location
Goto Forum:

Current Time: Wed Aug 23 22:14:18 CDT 2017

Total time taken to generate the page: 0.05422 seconds