Home » Other » Training & Certification » rollback uncommitted transaction, when system crash occur
rollback uncommitted transaction, when system crash occur [message #282515] Thu, 22 November 2007 04:05 Go to next message
oujar poudel
Messages: 5
Registered: November 2007
Junior Member
Hi

I have got a confusion over a question, kindly help me out.

Q1) Which background process will rollback the transactions (uncommitted) in case of system crash occurs?

a) if server machine crashes?
b) if client machine crashes?


I am confused over SMON & PMON, as both are said to do rollback.

Thanks..

OPoudel
Re: rollback uncommitted transaction, when system crash occur [message #282522 is a reply to message #282515] Thu, 22 November 2007 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
a) smon (or new server (shadow) process, the one that first reaches the block)
b) pmon (or smon if pmon does not terminate before instance shut down)

Regards
Michel

[Updated on: Thu, 22 November 2007 04:29]

Report message to a moderator

Re: rollback uncommitted transaction, when system crash occur [message #282533 is a reply to message #282515] Thu, 22 November 2007 04:48 Go to previous messageGo to next message
oujar poudel
Messages: 5
Registered: November 2007
Junior Member
Thanks...
Re: rollback uncommitted transaction, when system crash occur [message #282537 is a reply to message #282533] Thu, 22 November 2007 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Concepts
Chapter 9 Process Architecture
Section Overview of Oracle Processes
Subsection Background Processes
System Monitor Process (SMON)
Process Monitor Process (PMON)

Regards
Michel


Re: rollback uncommitted transaction, when system crash occur [message #282545 is a reply to message #282515] Thu, 22 November 2007 05:27 Go to previous message
oujar poudel
Messages: 5
Registered: November 2007
Junior Member
thanks..

But it is not clearly stated there.

Anyway,thanks.. a lot.

OPoudel
Previous Topic: What is "Query rewrite"? What is "materialized view"?
Next Topic: Index
Goto Forum:
  


Current Time: Thu Mar 28 16:43:55 CDT 2024