OraFAQ Forum: Training & Certification » rollback uncommitted transaction, when system crash occur

Home » Other » Training & Certification » rollback uncommitted transaction, when system crash occur

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rollback uncommitted transaction, when system crash occur [message #282515]

Thu, 22 November 2007 04:05

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

Report message to a moderator

Re: rollback uncommitted transaction, when system crash occur [message #282522 is a reply to message #282515]

Thu, 22 November 2007 04:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

oujar poudel
Messages: 5
Registered: November 2007

Junior Member

Thanks...

Report message to a moderator

Re: rollback uncommitted transaction, when system crash occur [message #282537 is a reply to message #282533]

Thu, 22 November 2007 04:55

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: rollback uncommitted transaction, when system crash occur [message #282545 is a reply to message #282515]

Thu, 22 November 2007 05:27

oujar poudel
Messages: 5
Registered: November 2007

Junior Member

thanks..

But it is not clearly stated there.

Anyway,thanks.. a lot.

OPoudel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 13:45:18 CST 2024