Home » Other » General » Which Background process is responsible for commit statement (10g, 10.2.0.4 (linux-4.5))
Which Background process is responsible for commit statement [message #566966] Fri, 21 September 2012 11:40 Go to next message
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
Re: Which Background process is responsible for commit statement [message #566969 is a reply to message #566966] Fri, 21 September 2012 12:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59126
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Which Background process is responsible for commit statement [message #566971 is a reply to message #566970] Fri, 21 September 2012 12:40 Go to previous messageGo to next message
Michel Cadot
Messages: 59126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Database Concepts

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

Regards
Michel
Re: Which Background process is responsible for commit statement [message #566973 is a reply to message #566971] Fri, 21 September 2012 13:14 Go to previous messageGo to next message
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
Re: Which Background process is responsible for commit statement [message #566975 is a reply to message #566973] Fri, 21 September 2012 13:25 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
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.
Re: Which Background process is responsible for commit statement [message #566976 is a reply to message #566975] Fri, 21 September 2012 13:38 Go to previous messageGo to next message
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
Re: Which Background process is responsible for commit statement [message #566978 is a reply to message #566973] Fri, 21 September 2012 13:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59126
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Which Background process is responsible for commit statement [message #566988 is a reply to message #566978] Fri, 21 September 2012 22:54 Go to previous messageGo to next message
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
Re: Which Background process is responsible for commit statement [message #566992 is a reply to message #566988] Sat, 22 September 2012 00:21 Go to previous message
Michel Cadot
Messages: 59126
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: vshost32.exe has stopped working
Next Topic: How(Where) to get Oracle Transparent gateway for sql server
Goto Forum:
  


Current Time: Thu Sep 18 08:58:27 CDT 2014

Total time taken to generate the page: 0.12553 seconds