| AWR and statspack usage on Oracle 10g Database [message #276203] |
Wed, 24 October 2007 06:23  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
