-
编辑 删除
How to Quiesce a Database
SQL> alter system quiesce restricted;alter system quiesce restricted*ERROR at line 1:ORA-25507: resource manager has not been continuously onSQL> alter system quiesce restricted;alter system quiesce r...
-
编辑 删除
Parallel query & views
session 1SQL> select sid from v$mystat where rownum=1; SID---------- 18 SQL>select /*+ parallel(a,4) */ * from temp_3006; print............ session 2 SQL> select sid,qcsid,ser...
-
编辑 删除
PLAN_TABLE_OUTPUT中的 *
SQL> explain plan for select a.* from t a,t b where a.num=b.num;Explained.SQL> select * from table(dbms_xplan.display);PLAN_TABLE_OUTPUT----------------------------------------------------------------...
-
编辑 删除
alter system disconnect/kill session 'sid,serial#';
alter system disconnect 'sid,serial#';1.session 1SQL> conn yxyEnter password: Connected.SQL> select * from t; NUM---------- 1SQL> update t set num=2 where num=1;1 row updated.2.session 2SQL> select sid,serial#,username from v$session where type='USER'; SID SERIAL# USERNAME---------- ---------- ------------------------------ 10 1 11 1 15 21625 SYS 20 9893 YXYSQL> select a.sid,a.serial#,a.username,b.spid
-
编辑 删除
alter system disconnect/kill session 'sid,serial#';
alter system disconnect 'sid,serial#';1.session 1SQL> conn yxyEnter password: Connected.SQL> select * from t; NUM---------- 1SQL> update t set num=2 where num=1;1 row updated.2.session 2...
-
编辑 删除
Log actively being archived by another process
今天在一台DB的alert.log中发现了以下信息。Tue Feb 27 12:33:09 2007ARC0: Completed archiving log 4 thread 1 sequence 15ARC0: Evaluating archive log 5 thread 1 sequence 16ARC0: Unable to archive log 5...
-
编辑 删除
ORA-02429: cannot drop index used for enforcement of unique/primary key
SQL> drop index UUID_PK; drop index UUID_PK *ERROR at line 1:ORA-02429: cannot drop index used for enforcement of unique/primary keySQL> SQL> select owner,CONSTRAINT_NAME,TABLE_NAME,CONSTRA...
-
编辑 删除
dp测试小记
为了将数据长期保留，最近公司上了一个备份恢复软件-HP Data Protector,这样可以将数据直接备份到tape上。周一开始学习(以前没有使用过)并正式测试这个软件,间边看文档边测试，同时要还处理一些杂事，所以测试进度有...
-
编辑 删除
使用生产DB的RMAN备份集恢复其他机器
生产DB的RMAN备份集恢复到其他的机器(简称目标DB)上使用，这样的恢复做过好多次了。虽然步骤较为简单，但是一直没有详细总结过。今天又奋战了几个小时，又恢复了一台，现在把步骤总结一下一.环境 生产DB环境 OS:HP-U...
-
编辑 删除
前两天升级时遇到了小问题(ORA-32004)
SQL> STARTUP;ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.Total System Global Area 413909504 bytesFixed Size 878156 bytesVariable Size ...
-
编辑 删除
2006-12-01 DB异常
在12月1号，偶的DB也中奖了，今天也总结一下。Alert.log错误信息如下ORA-01555 caused by SQL statement below (Query Duration=1164947392 sec, SCN: 0x0001.8d562fb5):Fri Dec 1 04:29:53 2006SELECT formatid, gl...
-
编辑 删除
ORA-00600: internal error code, arguments: [15709]
今天在DB的alert.log中发现以下错误: ORA-00600: internal error code, arguments: [15709], [2], [], [], [], [], [], [] 到metalink查看了一下，果然有所收获。 TIP: Click help for a detailed explanation of th...
-
编辑 删除
ORA-12838:
如果用了insert /*+ append */ into table as select .. from table 这样的操作来insert，必须在操作后commit,或是rollback,不然就不能再insert /*+ append */ into table as select .. from table 。ORACLE报出错误...
