Re: Killed session - does it rollback?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 12 Dec 2001 06:50:19 -0800
Message-ID: <F001.003DAB21.20011212052020@fatcity.com>

short answer: yes

longer answer: any time a session ends abnormally, anything it was doing that is uncommitted is rolled back. If pmon is gone, then smon takes over the rollback.

• Denham Eva <EvaD_at_TFMC.co.za> wrote:
  > Hi Gurus
  >
  > Just wondering, as DBA if I kill a session on the server. Does the
  > server
  > rollback the transaction automatically?
  >
  > TIA
  > Denham
  >
  >
  #####################################################################################
  > This e-mail message has been scanned for Viruses and Content and
  > cleared
  > by MailMarshal
  > For more information please visit www.marshalsoftware.com
  >
  #####################################################################################
  >
  

  ---

Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Dec 12 2001 - 08:50:19 CST