| indra |
Posted: Feb 07, 2007 10:14:24 AM |
Total Post: 20
Joined: Jan, 2007
|
| Pls tell me which type of data an Online Redo Log File contains,Commited or Uncommited? |
|
|
 maks2k |
| Posted: Feb 07, 2007 02:30:50 PM |  |
|
Total Post: 1
Joined: Feb, 2007
|
The online Redo log file contains the current online transactions(both committed n non committed ),the log writer writes the dirty buffer blocks to the Redo log files bcoz the redo log files are smaller in size compared to the large dbf's. once the user gives the commit, the DBWR process is invoked and the dirty buffers from the data base buffer blocks are written into the datafiles.
|
|
|
|
|
| kumar |
| Posted: Feb 14, 2007 01:04:53 PM | |
|
Total Post: 18
Joined: Nov, 2006
|
online redo contains all commited, uncommited and all trans details
which is used for recovery when database is lost.
|
|
|
|
|
| kumar |
| Posted: Feb 14, 2007 01:05:11 PM | |
|
Total Post: 18
Joined: Nov, 2006
|
online redo contains all commited, uncommited and all trans details
which is used for recovery when database is lost.
|
|
|
|
|
| Jayanta |
| Posted: Feb 26, 2007 01:01:37 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
redolog file also covers undo segment, and logwriter first writes log buffer to online redo log files then dbwn flushes dirty buffer cache to data files.
regards
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
