"Young, Geoffrey S." <[EMAIL PROTECTED]> writes:
>
> Incidentally, I have also noticed that on my Linux installation Oracle will
> not shutdown (or shutdown abort) while any of the httpd processes have
> persistent connections. That is, httpd must come down first for Oracle to
> shutdown cleanly. Just thought I'd mention it...
There are different kinds of shutdowns
shutdown - waits for every connection to disconnect
shutdown immediate - cleans up partially executed transactions
shutdown abort - leaves dirty blocks on disk which get cleaned up as needed
Shutdown immediate can take a while to execute but shutdown abort should be
fast. According to people on comp.databases.oracle.server unless you plan to
do a backup you can just use shutdown abort. A plain shutdown is useless for
web server databases unless you shut down every client including the web
server first, and even then it doesn't always seem to work.
In our experience pmon sometimes goes wonky if you shutdown abort and then
bring the database up. Tech support told us to shutdown abort, bring up the
database, then shutdown immediate and bring it up again. The second shutdown
cleans up the dirty blocks. I'm not sure if this is just superstition or
actually helps but that's what we do now.
--
greg
