OraFAQ Forum: General » Which Background process is responsible for commit statement

Home » Other » General » Which Background process is responsible for commit statement (10g, 10.2.0.4 (linux-4.5))

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

Which Background process is responsible for commit statement [message #566966]

Fri, 21 September 2012 11:40

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Hello All,

In an interview, interviewer asked me few questions, which i really don't know.

Please let me know what could be the answer for the below questions.

1) which process is responsible for rollback and commit Statement.
2) If user try unable to commit the statement, then what could be the reason? (Only one instance is active)

Waiting for your kind response...

Thanks,
Ishika

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566969 is a reply to message #566966]

Fri, 21 September 2012 12:03

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

Senior Member
Account Moderator

1) Your dedicated/shared server
2) Too many to be enumerated

Waiting for your kind response on these questions...

Regards
Michel

[Updated on: Fri, 21 September 2012 12:03]

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566970 is a reply to message #566969]

Fri, 21 September 2012 12:08

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Hi Michel,

Thanks for your kind response.

1) This question is for dedicate server. I would be thankful if you can answer me for both or if you can provide me any link.

2) tell me few about it.

I would be thankful if you can provide me link.

Regards,
Ishika

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566971 is a reply to message #566970]

Fri, 21 September 2012 12:40

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

Senior Member
Account Moderator

1) Database Concepts

2) Instance (lgwr) crash, process killed, disk failure...

Regards
Michel

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566973 is a reply to message #566971]

Fri, 21 September 2012 13:14

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear Michel,

Thanks for the link. But, unable to find out the answer from the provided link (LGWR process will act after the commit occur).
May be, i am not able to get the answer from the link. Can you please let me know which background process is responsible for the commit/rollback?

Waiting for the reply...

Regards,
Ishika Smile

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566975 is a reply to message #566973]

Fri, 21 September 2012 13:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Can you please let me know which background process is responsible for the commit/rollback?

When you start with the wrong question, no matter how good an answer you get, it won't matter very much.

It is NOT a background process that is responsible for the COMMIT/ROLLBACK.
The same client session/process that writes to the datafiles is responsible for COMMIT/ROLLBACK.

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566976 is a reply to message #566975]

Fri, 21 September 2012 13:38

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Thanks Michel / Blackswan,

Actually, user process is responsible for the statement. Once commit is done, LGWR processs will start writing into online redo log file.

I got the concept. Thanks for making me understand.

Regards,
Ishika

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566978 is a reply to message #566973]

Fri, 21 September 2012 13:41

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

Senior Member
Account Moderator

Quote:

LGWR process will act after the commit occur

Wrong, LGWR acts DURING the commit.

Quote:

Can you please let me know which background process is responsible for the commit/rollback?

Didn't you read my first answer?

Regards
Michel

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566988 is a reply to message #566978]

Fri, 21 September 2012 22:54

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear Mr. Michel,

Thanks for your answer. LGWR is the background process which is responsible for the commit / rollback statement.

Regards,

Ishika

Report message to a moderator

Re: Which Background process is responsible for commit statement [message #566992 is a reply to message #566988]

Sat, 22 September 2012 00:21

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

Senior Member
Account Moderator

This is part of the truth, and if in an interview one says this to me he will not success.

Regards
Michel

Report message to a moderator

Previous Topic:	vshost32.exe has stopped working
Next Topic:	How(Where) to get Oracle Transparent gateway for sql server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 09:59:27 CST 2024