commit delay on RAC environment
- From: "Steven Shing" <stevenshing@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 16 Mar 2006 12:42:50 +0800
Hi ,
In running rms_satotals_a.sh in daily batch, it fails when the committed
processing status of a store is not successfully read in a while loop. The
while loop loops through a number of stores contained in a table. The Script
contents show below,
sqlplus -s $LOGNAME1/$PASSWORD1@$connstr @$SCRIPTPATH/get_store_no.sql
while read LINE
do
$PGMFILEPATH/satotals $LOGNAME1/$PASSWORD1@$connstr $LINE
sleep 3
done < $OUTPTH/store_no.txt
It is suspected that this is caused by the max_commit_propagation_delay init
parameter setting (see 30761.1 for definition and 260304.1 for a problematic
situation).
1) Any similar experience re this parameter.
2) The current value used in HK and any recommended value for this parameter
Oracle recommends max_commit_propagation_delay=0 for Oracle Applications
running in RAC. Anyone experience the issue, Any suggestion will be
appreciated!!
TIA,
Cheers,
Steven
Other related posts:
- » commit delay on RAC environment
