| Log file sync [message #55115] |
Fri, 03 January 2003 17:28  |
Kumar
Messages: 115
Registered: December 1998
|
Senior Member |
|
|
|
We are facing 'log file sync' wait on one of table , when doing 'commit' after 'insert' . Do anybody know how to fix that.
|
|
|
|
|
|
| Re: Log file sync [message #55148 is a reply to message #55115] |
Tue, 07 January 2003 13:15  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
There are 3 main things you can do to help reduce waits on "log file sync":
- Tune LGWR to get good throughput to disk . eg: Do not put redo logs on RAID 5.
- If there are lots of short duration transactions see if it is possible to BATCH transactions together so there are fewer distinct COMMIT operations. Each commit has to have it confirmed that the relevant REDO is on disk. Reducing the overall number of commits by batching transactions can have a very beneficial effect.
- See if any activity can safely be done with NOLOGGING / UNRECOVERABLE options.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
