Fourth shutdown option

In SQL*Plus you can issue a "shutdown transactional" command which seems to function halfway between "shutdown normal" and "shutdown immediate". There is very little documentation we can find, although it appears we should be able to set a time limit for pending transactions to complete. Oracle will attempt to complete transactions until the time limit is reached then switch to shutdown normal.

Anyone know how we can set the time limit or have more information on shutdown transactional? Is it an argument? An init.ora parameter? Since this option has been around since Oracle 8, why does it never seem to be mentioned?

Thanks,

Van Received on Mon Oct 30 2000 - 17:54:37 CST