| Soumya |
Posted: Aug 31, 2007 07:44:36 AM |
Total Post: 56
Joined: Mar, 2006
|
Hi,
Please someone give me script to generate the Statspack report .
I want it to execute through crontab.
Thanx
|
|
|
 Mohammed Taj |
| Posted: Sep 01, 2007 01:10:18 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
It is better if you give us oracle version also ???
but if you 10g use just "awrrpt.sql" and run with DBA privs.
Located: $ORACLE_HOME/rdbms/admin/awrrpt.sql
it will generate statpack report.
through crontab utility you can schedule this script.
Regards
Taj
|
|
|
|
|
| Soumya |
| Posted: Sep 03, 2007 04:43:01 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
|
|
|
|
| Mohammed Taj |
| Posted: Sep 03, 2007 04:59:30 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
Always specify Oracle Version ???
and for oracle 9i you can generate statspack report.
http://dbataj.blogspot.com/2007/05/statspack.html
regards
Taj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
