-
编辑 删除
VLDB and Partitioning Guide 读书摘要
1、If a global index partition contains data, dropping the partition causes the next highest partition to be marked unusable. You cannot drop the highest partition in a global index. p2-142、The highest partition of a global index must have a partition bound, all of whose val...
-
编辑 删除
Fatal NI connect error 12170 TNS-12535 TNS-00505
Fatal NI connect error 12170 TNS-12535 TNS-00505今天一位朋友遇到这个错误，每2个小时长时间运行的存储过程就断开，一开始怀疑PROFILE或者RESOURCE PLAN限制。但是大家都明白，一般很少用这些，特别是资源计划，拿到报错后如下：Fatal NI connect e...
-
编辑 删除
BULK和FORALL对比普通游标的性能
BULK和FORALL对比普通游标的性能表testbl是一个简单的300W的表，大小为88M，create table TESTBL( ID INTEGER, NAME VARCHAR2(20))没有索引，ID列为自增，NAME列为常量+自增；表testbl3和表testbl结构一样，数据来自两次INSERT INTO TESTBL，增加索引在ID列。进行如下语句测试语句1 记为...
-
编辑 删除
kill session V$SESSION标记为KILLED 的2种情况
If the session is not making a SQL call to Oracle (is INACTIVE) when it is terminated, the ORA-28 message is not returned immediately. The message is notreturned until the user subsequently attempts to use the terminated session.When an inactive session has been terminated, STATUS in the view V...
-
编辑 删除
ORA-30926 及MERGE 临时表空占用问题
今天进行MERGE操作的时候是根据两个2个大表大约每张表10G左右，进行更新，服务器使用了PCI-E闪存盘，速度还是相当快的，大概语句如下：merge into TEST_EVENT ausingTEST_EVENT_1 bon(a.MAIN_TARGET=b.MAIN_TARGET and a.EVENT_TYPE=b.EVENT_TYPE)when matched thenupdateseta.CARD_NO=b.CARD_NO,a.EVENT_ACCO...
