WINDOWS下的程序员出身，偶尔也写一些linux平台下小程序， 后转行数据库行业，专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群：58308065，23618606
全部博文（599）
发布时间：2013-03-22 13:22:48
SQL> select * from t where object_id in (select object_id from t_object);Execution Plan----------------------------------------------------------Plan hash value: 2048262264--------------------------------------------------------------------------------------| Id | Operation &nbs.........【阅读全文】
发布时间：2013-02-28 14:06:45
Physical and Logical Block Corruptions. All you wanted to know about it. [ID 840978.1]Oracle classifies the Data File Block corruptions as Physical and Logical. This is also referred as intra block corruptions. This document is intended to provide detailed informati.........【阅读全文】
发布时间：2013-02-27 15:08:40
本文信息来在ORACLE SUPPORT Tracing the Database Configuration Assistant (DBCA) [ID 188134.1]PurposeThe purpose of this document is to assist in debugging Database Configuration Assistant problems and enable DBCA trace.ScopeThis document is for DBAs and .........【阅读全文】
发布时间：2013-02-27 13:50:21
http://www.ixora.com.au/notes/controlfile_structure.htm The first block of the controlfile is a header block that records just the controlfile block size and the number of blocks in the controlfile. The controlfile block size is the same as the database block size. When mounting a datab.........【阅读全文】
发布时间：2013-02-20 16:07:28
带绑定变量的SQL用AUTOTRACE查询执行计划还真不靠谱，测试发现AUTOTRACE的SQL不会进行绑定变量探测。 SQL> DESC T 名称 是否为空? 类型 --------.........【阅读全文】
前期吸引人啊