FAQ

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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 8 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 19, '06 at 7:09p
activeSep 20, '06 at 3:19p
posts8
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase