log
file sync
|
Oracle foreground
processes are waiting
for a COMMIT or ROLLBACK to complete |
Tune LGWR to get good
throughput to
disk eg: Do not put redo logs on RAID5
Reduce overall number of
commits by
batching transactions so that there are fewer distinct COMMIT operations |
Reference Note# 34592.1
High Waits on log file
sync Note# 125269.1
Tuning the Redolog Buffer
Cache and Resolving Redo Latch Contention
Note# 147471.1
|
OCM | AWS | 6XOCI Certified - Smart grid, DB, Cloud, EXADATA/ODA, Bigdata Analytics, IOT & Cyber security Solutions
Wednesday, February 15, 2017
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment