Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

11

主题
1#
发表于 2013-5-31 08:53:44 | 查看: 1947| 回复: 1
在Troubleshooting: "log file sync" Waits [ID 1376916.1]这篇文档里介绍减缓logfile sync等待事件的方法
Check to see if redo logs are large enough
A 'log file sync' operation is performed every time the redo logs switch to the next log to ensure that everything is written before the next log is started. Standard recommendations are that a log switch should occur at most once every 15 to 20 minutes. If switches occur more frequently than this, then more 'log file sync' operations will occur meaning more waiting for individual sessions.

红色字体部分爱怎么理解,logfile sync和log file  switch的关系?
2#
发表于 2013-6-1 15:43:01
log file  switch会触发logfile sync等待事件,在下一个redo使用前确保log buffer的信息都写入到磁盘

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 15:30 , Processed in 0.053328 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569