Possible Causes :
· Oracle foreground processes are waiting for a COMMIT or ROLLBACK to complete
Actions :
· 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
No comments:
Post a Comment