| log file sync? [message #120070] |
Tue, 17 May 2005 10:56  |
confident
Messages: 28
Registered: March 2005
|
Junior Member |
|
|
well,my database is 8.1.7, in every statspack report, iam seeing in top 5 wait events the log file sync? can be tell me what is log file sync...
Top 5 Wait Events
~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
log file sync 184,512 240,604 8.20
how to calculate from above report whether it's normal or abnormal? please tell me
|
|
|
|
| Re: log file sync? [message #120074 is a reply to message #120070] |
Tue, 17 May 2005 11:54  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
heavy log_file_sync_waits in comparison to write requests means LGWR is taking too much time to transfer data from redo buffer to redo log file.
Way out is to tune commit & checkpoint.
|
|
|
|
| Re: log file sync? [message #120127 is a reply to message #120074] |
Tue, 17 May 2005 18:55 |
confident
Messages: 28
Registered: March 2005
|
Junior Member |
|
|
how to calculate from above report whether it's normal or abnormal? By this wait, wait time(TS) % Total Wt Time
),
any value calculation
please tell me
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
