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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic: pga_aggregate_target increase during migration ?
Next Topic: Temp table space not released
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:48:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.