-
编辑 删除
constraint states
constraint states includes:ENABLE ensures that all incoming data conforms to the constraintDISABLE allows incoming data, regardless of whether it conforms to the constraintVALIDATE ensures th...
-
编辑 删除
关于procedure的lock和pin
procedure在执行过程中出现的lock和pinselect KGLNAOBJ,KGLNAOWN,KGLHDPMD,KGLHDLMD from x$kglob where KGLHDPMD>0;KGLNAOBJ &nb...
-
编辑 删除
Automatic Statistics Gathering
在Oracle10g中引入的优化器统计信息（Optimizer Statistics）自动收集，是一个看上去很不错的功能，但是在实际应用中却往往没有起到相应的效果，甚至在某些系统中我们会建议禁用这个功能。阐述一些该功能的相关知识...
-
编辑 删除
RAC Connection Redirected To Wrong Host/IP ORA-12545
Doc ID: Note:364855.1 Type: PROBLEM Last Revision Date: 23-APR-2007 Status: PUBLISHED In this Document Symptoms Cause Solution References-------...
-
编辑 删除
圣斗士星矢243年前的圣战详细介绍
1743年的上代黄金圣斗士 白羊座-史昂 金牛座-白杨 双子座-薛安 巨蟹座-妖 狮子座-艾文斯 处女座-假面 天秤座-童虎 天蝎座-翔 射手座-月华 摩羯座-艾沙 水瓶座-施恩 双鱼座-穆沙 据说上界的双鱼座黄金圣斗士...
-
编辑 删除
ddl和library cache lock
1、ddl操作过程中会阻塞select操作，并会产生library cache lock等待事件2、ddl操作实际上就是对系统表做dml操作，library cache lock其实就是在dml系统表过程中对row的x lock3、ddl操作和普通dml操作的区别在于，...
-
编辑 删除
oracle10g AWR
Oracle10G自动工作负荷储存库(AWR)在oracle10G中引进了两个新的进程:mmon和mmnl，其中MMON承担了大部分的工作。以用来从SGA中直接收集统计数据。这些数据都存储在SYSAUX表空间中，并且以WRM$_* 和 WRH$_*的格式命名...
-
编辑 删除
Memory Configuration and Use
Calculating the Buffer Cache Hit RatioSELECT NAME, VALUE FROM V$SYSSTATWHERE NAME IN ('session logical reads','physical reads', 'physical reads direct','physical reads direct (lob)')...
-
编辑 删除
Memory Architecture
Database Buffer CacheThe database buffer cache is the portion of the SGA that holds copies of data blocks read from datafiles. All user processes concurrently connected to the instance share access t...
-
编辑 删除
IBM系列AIX小型机巡检项目及流程参考
IBM系列AIX小型机巡检项目及流程参考1、机器型号# uname -uMIBM,7029-6E3 IBM,01100550A2、检查系统硬件设备故障灯是否有亮3、系统错误报告# errpt -d H -T PERM //硬件的错误报告IDENTIFIER TIMESTAMP&n...
-
编辑 删除
Fast Connection Failover
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/fstconfo.htm#CEGGDDFJ
-
编辑 删除
RAC TAF
Overview of Transparent Application Failover (TAF) The TAF function is controlled by processes external to the Oracle Database 10g RAC cluster control. The cl...
-
编辑 删除
Viewing Histograms
Viewing HistogramsColumn statistics may be stored as histograms. These histograms provide accurate estimates of the distribution of column data. Histograms provide improved selectivity estimates in t...
-
编辑 删除
关于大表的带条件分批删除
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production要执行的操作是delete dbcrmadm.dCustGrpUserShould where acct_month='200901'；应用反映操作很慢。select count(*) from dbcrmadm.dCustGrpUs...
-
编辑 删除
rman backup algorithm
Algorithm RulesThe basic backup algorithm follows several important tenets when creating backup sets. Eachallocated channel that performs work in the backup job—that is, each channel that is not idle...
-
编辑 删除
ORADEBUG
一、 概要首先看看helpSQL> oradebug helpHELP [command]  ...
-
编辑 删除
the TWO PHASE COMMIT
(01) The global coordinator initiates and commits the distributed transaction. During execution of the SQL statements within the transaction, the defini...
-
编辑 删除
字符集总结
1、NLS_LANG指定客户端使用何种字符集显示数据库的字符2、插入数据库时，NLS_LANG指定insert时用的字符集，当直接在客户端的sqlplus中insert时候不管你实际使用何种字符集，都认为是NLS_LANG指定的字符集，因为sqlp...
-
编辑 删除
Viewing Index Information
The following views display information about indexes:ViewDescriptionDBA_INDEXES ALL_INDEXES USER_INDEXESDBA view describes indexes on all tables in the database. ALL view describes index...
-
编辑 删除
IMP过程中对象丢失
imp过程中丢失了两个表三个索引，再日志中出现了 " ALTER TABLE "TPHS_PHS_INFACE" MODIFY ("DEAL_FLAG" DEFAULT '0'" " ALTER TABLE "TPHS_SHT_MGR" MODIFY ("HL_FLAG_ID" DEFAULT 0"丢失右括号的报错，这是...
