Oracle System Authentication Sample

export ORACLE_HOME=/sysp/ora/ora10g_rac/product/10.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=sid_name

${ORACLE_HOME}/bin/sqlplus /nolog << EOF
CONNECT / as sysdba

-- nowait
alter system set commit_write='IMMEDIATE, NOWAIT' scope=both;

-- fallback
-- alter system set commit_write='IMMEDIATE' scope=both;

select inst_id, name, value from gv$parameter where name like '%commit_write%'

commit;
exit;

EOF