When does the LGWR writes all redo-enteries to the redo-log buffer?
Submitted by: AdministratorLGWR writes one contiguous portion of the buffer to disk. LGWR writes:
1. A commit record when a user process commits a transaction
2. Redo log buffers
– Every three seconds
– When the redo log buffer is one-third full
– When a DBWn process writes modified buffers to disk, if necessary
Submitted by: Administrator
1. A commit record when a user process commits a transaction
2. Redo log buffers
– Every three seconds
– When the redo log buffer is one-third full
– When a DBWn process writes modified buffers to disk, if necessary
Submitted by: Administrator
Read Online Concepts and Architecture Job Interview Questions And Answers
Top Concepts and Architecture Questions
| ☺ | What is a Segment in Oracle? |
| ☺ | Explain can a Tablespace hold objects from different Schemes? |
| ☺ | Explain what is the function of Redo Log? |
| ☺ | What is Oracle Identity Analytics? |
| ☺ | Explain what is Public Database Link? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
