Re: SQL Statement Shutdown

From: Patrice Castet <patrice.castet_at____nospaaaaam____in-fusio.com>
Date: Mon, 03 Mar 2003 14:40:47 GMT
Message-ID: <3e6368db.22201921@read.news.fr.uu.net>

what do you want to shutdown ? the database ? a dispatcher ? by the way "shutdown abort" is like you "kill" your database, it has to perform a recovery when restarting !
I advice you to use "shutdown immediate" which stop it cleanly instead of "abort". The "abort" option must not be used except for emergency issues.

On Mon, 3 Mar 2003 11:26:51 +0200, "James" <james_at_nothing.com> wrote:

>Hi there
>I've also posted this question on comp.databases.oracle.server!
>I want to shutdown using a sql statement. The SQL plus statement is SHUTDOWN
>ABORT
>What is the SQL statement for this?
>I thought it was ALTER SYSTEM SHUTDOWN dispatcher_name but it is not working
>for me.
>
>I'm using Oracle 9 on windows
>Cheers
>James
>
>
>
Received on Mon Mar 03 2003 - 08:40:47 CST