-
2008-06-06 14:24:02
/ Oracle数据库管理
os: linux as4 u5 64bitdb: oracle 10.2.0.3 racnode1:SQL> SELECT COUNT(0) FROM test.tab_1;COUNT(0)----------1596576Elapsed: 00:00:02.57SQL>node2 :SQL> SELECT COUNT(0) FROM test.tab_1;同样的sql 就是查询不出结果.这时 查看 v$session_wait : 等待事件:gc cr multi block request如果在node1上 flush buffer_cache , node2 马上就出来结果了.原帖子: http://www.itpub.net/thread-998912-1-1.html
查看(179)
评论(7)
-
2008-06-03 09:50:07
/ Oracle数据库管理
os : redhat linux u5db : oracle 10.2.0.3 rac[php]rac1:SQL> set time on;09:35:58 SQL> SELECT COUNT(0) FROM tab_test;COUNT(0)----------106289609:36:03 SQL>rac2:09:36:52 SQL> select * from v$mystat where rownumSELECT COUNT(0) FROM tab_test;SELECT COUNT(0) FROM tab_test*ERROR at line 1:ORA-01013: user requested cancel of current operationSQL> SELECT n.SID,n.EVENT,n.P1TEXT,n.P1,n.P2TEXT,n.P2,n.WAIT_CLASS,n.WAIT_TIME FROM
查看(933)
评论(35)
-
2008-01-24 19:45:51
/ Oracle数据库管理
我在node1 上利用 lvcreate 创建逻辑卷 .怎么能看 node2 看到呢?看hp-unix 可以用vgexportmyfile datavg 让后在vgimport 到node2 上.那么在linux 上怎么办呢?我参考了yangtingkun 的安装文档上没有具体说明.http://yangtingkun.itpub.net/post/468/213417
查看(339)
评论(5)
-
2008-01-15 11:20:43
/ Oracle数据库管理
今天早上发现数据库已经关闭.startup时发现错误.原来是硬盘有损坏.简单做了一下记录.DB :ORACLE 9204OS :CentOS AS4-- startup 数据库发现如下错误SQL> startupORACLE instance started.Total System Global Area 420549952 bytesFixed Size 451904 bytesVariable Size 201326592 bytesDatabase Buffers 218103808 bytesRedo Buffers 667648 bytesDatabase mounted.ORA-16038: log 2 sequence# 326 cannot be archivedORA-00333: redo log read error block countORA-00312: online log 2 thread 1:
查看(281)
评论(4)
-
2008-01-02 13:24:38
/ Oracle数据库管理
[php]create table TAB_A(IDVARCHAR2(20) not null,R_DATE VARCHAR2(20) not null);alter table TAB_Aadd constraint PK_TAB_A_ID primary key (ID);create index IND_TAB_B_R_DATE on TAB_A (SUBSTR(R_DATE,1,10));create table TAB_B(IDVARCHAR2(30) not null,P_DATE VARCHAR2(20) not null);alter table TAB_Badd constraint PK_TAB_B_ID primary key (ID);create index IND_TAB_B_P_DATE on TAB_B (SUBSTR(P_DATE,1,10));test@test.us.oracle.com
查看(383)
评论(9)
-
2007-12-19 16:45:24
/ Oracle数据库管理
os:LINUX AS4DB :9204Wed Dec 19 09:52:41 2007KCF: write/open error block=0x589 online=1file=3 /opt/oracle/oradata/oadb/oa_data.dbferror=27072 txt: 'Linux Error: 5: Input/output errorAdditional information: 1416'Automatic datafile offline due to write error onfile 3: /opt/oracle/oradata/oadb/oa_data.dbf什么导致datafile 的状态为RECOVER .alter database datafile 3 offline;ALTER DATABASE RECOVERdatafile 3;alter database datafile 3 online;这样data
查看(549)
评论(14)
-
2007-12-11 19:08:41
/ Oracle数据库管理
oralce ： 9201os: win2000 sp4ora-08104 The index is being created or rebuild or waited for recovering from the online (re)build.alter index index_name rebulid online ;kill掉session后。drop index index_name ;还是提示：ora-08104 ；drop table table_name ;-- 索引所在的表还是提示：ora-08104 ；drop table SYS_JOURNAL_[objid];truncate table table_name; -- 要做好备份。drop index index_name ;就是提示：ora-08104 ; （看到ifree的帖子说他truncte后，就可以drop inde
查看(400)
评论(7)
