OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » ADDM Retention (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ADDM Retention [message #488289]

Thu, 06 January 2011 03:28

vnkumaresh
Messages: 9
Registered: December 2010

Junior Member

Hi,

My database is running in 10.2.0.4. I have AWR retention as 30 days. While i am running addmrpt.sql its only showing last 3 days snapshots. Why it is showing only 3 days as my AWR retention is 30 days ?

Regards,
Kumaresh

Report message to a moderator

Re: ADDM Retention [message #488295 is a reply to message #488289]

Thu, 06 January 2011 04:15

wcorafaq
Messages: 2
Registered: August 2006
Location: IDHAO

Junior Member

The addmrpt.sql script has a default value of 3 for num_days.
So update it for number you require.

SQL> define num_days = 10;
SQL> define report_name = /tmp/addm_report_10_11.txt
SQL> @@?/rdbms/admin/addmrpti

all options:
Rem define dbid = 1234567890;
Rem define inst_num = 1;
Rem define num_days = 3;
Rem define report_name = /tmp/addm_report_10_11.txt
Rem define begin_snap = 10;
Rem define end_snap = 11;
Rem @@?/rdbms/admin/addmrpti

Report message to a moderator

Re: ADDM Retention [message #488321 is a reply to message #488295]

Thu, 06 January 2011 06:28

vnkumaresh
Messages: 9
Registered: December 2010

Junior Member

HI,

Thanks for yourhelp on this.

Regards,
Kumaresh

Report message to a moderator

Previous Topic:	Procedure runs long time (merged)
Next Topic:	Disk Performance Issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 16:16:38 CDT 2024