Home » RDBMS Server » Server Administration » Threshold value
Threshold value [message #194774] Mon, 25 September 2006 04:33 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi
i have to write a solaris shell script to monitor the archive log file growth in o/s level.So i have to fix an threshold value in my script,like the below mentioned:

THRESHOLD_PCT=1
export THRESHOLD_PCT
echo $THRESHOLD_PCT

AS in the above example if i set it to 1,what it means whether that 1 is a KB or MB or GB or any percentage value.

Please help me. Embarassed

Thanks
Raaj

Report message to a moderator

Re: Threshold value [message #194789 is a reply to message #194774] Mon, 25 September 2006 05:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is THRESHOLD_PCT supposed to represent? And what are you gaining by monitoring the archive log "growth" ?

Report message to a moderator

Re: Threshold value [message #194792 is a reply to message #194789] Mon, 25 September 2006 06:04 Go to previous message
thiyagaraj
Messages: 41
Registered: August 2006
Member
By monitoring the archive log "growth" ,restricts the archive log generation to that THRESHOLD_PCT value set.By doing so we can avoid the archive log space overflow error.

Report message to a moderator

Previous Topic: Default Temporary Tablespace
Next Topic: Multiplexing of Redo Log Files to Different O/S
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:20:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.