Topic: Database Administration >> log writer
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| anil |
Posted: Jan 21, 2008 03:08:21 PM |
Total Post: 27
Joined: Dec, 2007
|
| how the database log writer works and why we use it? |
|
|
 Vinod |
| Posted: Jan 21, 2008 09:38:04 PM |  |
|
Total Post: 54
Joined: Oct, 2007
|
Hi Anil,
The log writer process (LGWR) is responsible for redo log buffer
management ,writing the redo log buffer to a redo log file on disk.
LGWR writes all redo entries that have been copied into the buffer since the last time it wrote.
-Vinod
|
|
|
|
|
| Vaibhav |
| Posted: Jan 24, 2008 05:00:04 AM | |
|
Total Post: 11
Joined: Jan, 2008
|
Hi Anil,
When we commit a transaction it is not mandatory for DBWn to write the updated information into data file.LGWn writes the updated information in online redo log file from redo buffers so that in case of any instance crash the modified data will not be lost.At Instance recovery time SMON read this information from online redo log file and update the values in respected tables.
Bacically LGRw works for recovery purpose.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
