Home » RDBMS Server » Server Administration » STOP AWR SNAPSHOT (Oracle Database 10.2.0.1.0 Linux 2.6.18-8.el5)
STOP AWR SNAPSHOT [message #402686] Tue, 12 May 2009 01:33 Go to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
Hi all, I would like to know is their any way to stop the automatic snapshot taken by AWR.thnx in advance
Re: STOP AWR SNAPSHOT [message #402699 is a reply to message #402686] Tue, 12 May 2009 02:10 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>o know is their any way to stop the automatic snapshot taken by AWR

How your taking awr report??

babu
Re: STOP AWR SNAPSHOT [message #402701 is a reply to message #402686] Tue, 12 May 2009 02:19 Go to previous message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
after 24 hours,but i have just find the solution which might be correct in say, if u put interval attribute of package DBMS_WORKLOAD_REPOSITORY to 0 then it will stop taking automatic snapshot.thnx
Previous Topic: pga_aggregate_target increase during migration ?
Next Topic: Temp table space not released
Goto Forum:
  


Current Time: Sat Dec 14 16:26:17 CST 2024