2017年03月_czmmiao

原创 log file sync总结

log file sync等待时间发生在redo log从log buffer写入到log file期间。下面对log file sync做个详细的解释。何时发生日志写入： 1.commit或者rollback 2.每3秒 3.log buffer 1/3满或者已经有1M的redo数据。更精确的解释：_LOG_IO_SIZE 大小默认是LOG_BUFFER的...

2017-03-09 14:36:47 213

原创 Troubleshooting: "log file sync" Waits (文档 ID 1376916.1)

What is a 'log file sync' wait? When a user session commits, the session's redo information needs to be flushed from memory to the redo logfile to make it permanent. At the time of commit, the...

2017-03-09 14:32:15 240

原创 Oracle Log File Sync Wait Event

The Oracle “log file sync” wait event is triggered when a user session issues a commit (or a rollback). The user session will signal or post the LGWR to write the log buffer to the redo log file. Whe...

2017-03-08 18:46:38 285

原创 Tuning ‘log file sync’ Event Waits

Tuning ‘log file sync’ Event Waits by Riyaj Shamsudeen June 27, 2008 Posted in: Technical Track Tags: Oracle In this blog entry, I will discuss strategies and techniques to resolve ...

2017-03-08 18:41:01 402

原创 Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2)

Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2) by Tanel Poder Posted on November 6, 2013 In my previous post ( Advanced Oracle Troubleshooting Guide – Part 11: Complex...

2017-03-08 16:56:34 307

原创 Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature An

Here’s a treat for the hard-core Oracle performance geeks out there – I’m releasing a cool, but still experimental script for ASH (or poor-man’s ASH)-based wait event analysis, which should add a who...

2017-03-08 16:05:21 282

原创 Oracle 10046 SQL TRACE

为什么我们要使用10046 trace? 10046 trace帮助我们解析一条/多条SQL、PL/SQL语句的运行状态，这些状态包括：Parse/Fetch/Execute三个阶段中遇到的等待事件、消耗的物理和逻辑读、CPU时间、执行计划等等。即10046 为我们揭示了一条/多条SQL 的运行情况，对于以点入手的 SQL调优是很好的辅助工具，特别是在 10g之前没有A...

2017-03-08 15:19:14 182

原创机器学习网址整理

http://lectures.quantecon.org/_static/pdfs/py-quant-econ.pdf http://linear.ups.edu/curriculum.html http://www.extension.harvard.edu/open-learning-initiative/abstract-algebra http://www.opentextbo...

2017-03-05 07:54:35 209

czmmiao的专栏