Search Results

Is there any need for you to tune it? I don't know about a best practice for it but leaving it to default until there might be any need for it to be tuned.
Did you have any problems with the Dead...

Afaik 20 is the default.

better write a SQL script which will have all steps to shutdown DB. Pass your necessary information as argument to script and execute it from ksh file in silent mode.
like -


inside ksh file...

#!/usr/bin/ksh
for db in `grep ":Y" /etc/oratab | awk -F":" '{print $1}'`
do
prunc=`ps -ef | grep -i pmon | awk '{print $NF}' | awk -F _ '{print $3}' | grep -c "${db}"`
if [ ${prunc} -eq 1 ]...