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: Session problem
Next Topic: Instance terminate by lgwr process - error 470
Goto Forum:

Current Time: Tue Oct 25 02:15:37 CDT 2016

Total time taken to generate the page: 0.12843 seconds