What does the Log File Parallel Write event of the V view indicate?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What does the Log File Parallel Write event of the V view indicate?
Rating:
The Log File Parallel Write event of the V view specifies the time taken by the log writer (LGWR) process to write the redo entries from the redo log buffer to the online redo logs. This event is useful in tuning redo logs. A high or increasing value of this event is an indication of a probable redo log contention.
Rating:
Was this information helpful?
Other articles
- How does Database Resource Manager perform database resource management?
- What is shared pool?
- What are Oracle background processes?
- What is undo space?
- What is pending area?