Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> pmon & smon transaction recovery/rollback

pmon & smon transaction recovery/rollback

From: amonte <ax.mount_at_gmail.com>
Date: Wed, 31 Jan 2007 12:53:45 +0100
Message-ID: <85c1fb130701310353o74b8f0c4o7836cc874ee92b5b@mail.gmail.com>


Hi

I have a basic question, we all know that pmon's task is to cleanup resource by failed processes such as rolling back transaction, releasing locks and resources etc. We also know that smon rolls back uncommited transactions after instance failure.

My question is, I killed a couple of processes this morning and smon went crazy performing parallel recovery, I was wondering shouldnt that pmon's job? There was no instance failure.

TIA Alex

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 31 2007 - 05:53:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US