今天偶尔碰到一个ORA-600错误：
[oracle@honcho ~]$ sqlplus sys/oracle@honcho as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Sat Oct 29 18:25:11 2011[……]
处理一个ORA-00600: internal error code, arguments: [keltnfy-ldmInit] 错误
October 29, 2011 maintain, oracle No comments ORA-600
基于foreign key 没有index引起的ssx锁等待的测试
October 27, 2011 maintain, oracle 2 comments dead lock
创建测试环境：
[oracle@yang ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 10.2.0.4.0 – Production on Thu Oct 27 00:03:46 2011
Copyright (c) 1982,[……]
data_object_id
October 24, 2011 Internals, oracle 1 comment oracle data
xxx_objects.data_object_id differs from object_id after
* truncate table (or alter table truncate partition), unless table/partition is empty
*[……]
datafile Checkpoint cnt
October 24, 2011 Internals, oracle 2 comments oracle data
通过dump datafile header 发现每个Checkpoint cnt不同
大致原因如下：
1.tablespace 建立的时间不同 现在我们新建一个tablespace ->liu datafile->liu01.dbf
DATA FILE #10:
(name #[……]
使用dbms_rowid恢复可用数据
October 22, 2011 maintain, oracle 5 comments 恢复
最近看到同事的一个案例，觉得很有趣 现在测试下：
SQL> select * from v$version;
BANNER
—————————————————————-
Oracle Database 1[……]
SYSAUX 表空间问题解决
October 19, 2011 maintain, oracle No comments oracle数据管理
通过awrinfo.sql 以及 v$sysaux_occupants对SYSAUX空间分析，发现OPTSTAT（历史统计信息）相关的表占用近28G，AWR相关占用空间4G多，经分析OPTSTAT的历史
统计信息系统会自动清理失败有如下原因:因为历史统计信息较多，通过DBMS_STATS.PURG[……]
Why ASMLIB and why not?
October 19, 2011 oracle, RAC 2 comments asm
ASMLIB是一种基于Linux module，专门为Oracle Automatic Storage Management特性设计的内核支持库
(kernel support library)。
长久以来我们对ASMLIB的认识并不全面，这里我们来具体了解一下使用ASMLIB的优缺点。[……]
sqlnet.ora 控制访问IP
October 19, 2011 network, oracle 3 comments oracle TNS
sqlnet.ora中进行下列参数的设置可以限制或允许用户从特定的客户机连接到数据库中
[root@Hong ~]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:0C:29:24:93:F5
inet addr:192.168.1.[……]
Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites
October 17, 2011 advanced tech, oracle 7 comments 物化视图
We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query redirectio[……]
ORACLE – 9i to 10g database Upgrade using DBUA.
October 17, 2011 migration, oracle No comments oracle Install
Purpose of this document is to show a complete 9i to 10g upgrade of an Oracle database on
AIX 5L using DBUA ( Database Uprgrade Assistant)
3.2 T[……]