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

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.


Thanks
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

AFAIK No,
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.

Regards
Mohammed Taj
Previous Topic: Session problem
Next Topic: Instance terminate by lgwr process - error 470
Goto Forum:
  


Current Time: Wed Dec 07 09:07:00 CST 2016

Total time taken to generate the page: 0.10358 seconds