Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: alter database recover managed standby database disconnect from session;
On Tue, 2006-09-19 at 14:00 -0600, Reidy, Ron wrote:
> What does this mean? Are you saying that you can still issue SQL
> statements?
>
>
>
> Obviously, the prompt returns, but is the session still active? Is it
> in the process list of v$session/v$process?
>
Hi Ron,
here is the discription of the disconnect clause from the SQL Reference:
"DISCONNECT Specify DISCONNECT to indicate that Redo Apply should be performed in the background. Doing so leaves the current session available for other tasks. The FROM SESSION keywords are optional and are provided for semantic clarity."
So for me, without testing, it seems that something like a nohup from the unixworld is happening, if you use this clause.
hth
Jörg
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 20 2006 - 07:42:17 CDT
![]() |
![]() |