What will happen after commit statement ?

bhavana · 23-01-07, 02:53 PM

What will happen after commit statement ? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

ajithcharles · 26-01-07, 08:59 PM

the dirty blocks present in the Database will be written to the disk from the
SGA. This is done by a process called DBWR if i am right read as Database writer.

mymailbox.21 · 13-03-08, 05:28 PM

small correction in your statement ajith.

when commit occurs, first LGWR(log writer) writes the redo entries from redo log buffer cache to redo log files in the database.

then DBWR(database writer) writes the dirty blocks or dirty buffers from write list of database buffer cache to corresponding datafiles.

23-01-07, 02:53 PM	#1 (permalink)
bhavana Senior Member Join Date: Jan 2007 Posts: 598 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 7	What will happen after commit statement ? What will happen after commit statement ? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

26-01-07, 08:59 PM	#2 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: What will happen after commit statement ? the dirty blocks present in the Database will be written to the disk from the SGA. This is done by a process called DBWR if i am right read as Database writer. __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

13-03-08, 05:28 PM	#3 (permalink)
mymailbox.21 Junior Member Join Date: Mar 2008 Age: 25 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What will happen after commit statement ? small correction in your statement ajith. when commit occurs, first LGWR(log writer) writes the redo entries from redo log buffer cache to redo log files in the database. then DBWR(database writer) writes the dirty blocks or dirty buffers from write list of database buffer cache to corresponding datafiles.

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
C language - When is a switch statement better than multiple if statements?	GEEK	ds. c , c++ Interview / Technical Questions	3	08-02-08 03:48 PM
C language - What does it mean when a pointer is used in an if statement	GEEK	ds. c , c++ Interview / Technical Questions	0	23-01-07 01:41 PM
C language -When is a switch statement better than multiple if statements?	GEEK	ds. c , c++ Interview / Technical Questions	0	23-01-07 01:18 PM
Statement from Microsoft on Establishment of Technology Coalition	wizkid	Latest Tech News & Innovations	0	27-07-06 07:55 PM
regarding oracle versions	Madhuri	ORACLE , SQL SERVER , SYBASE & Others	7	07-07-06 07:06 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)