RT用runstats 收集的统计信息如何删除另外with distribution是什么意思还有就是如何 导出统计信息db2look -d testdb -t test.t -m -o t.sql好像不行啊总是这个结果：UPDATE SYSSTAT.FUNCTIONSSET ios_per_invoc= -1.0,insts_per_invoc= -1.0,ios_per_argbyte= -1.0,insts_per_argbyte= -1.0,percent_argbytes= -1,initial_ios= -1.0,initial_insts= -1.0,cardinality= -1.0;COMMIT WORK;CONNECT RESET;TERMINATE;[ 本帖最后由 fjmingyang 于 2008-11-13

db2迁移到oracle有哪几种方式db2迁移到oracle有哪几种手段，这些手段更有什么利弊？请问哪有详细的论述？谢谢

db2迁移到oracle有哪几种手段，这些手段更有什么利弊？请问哪有详细的论述？谢谢

db2 => connect to ocrmSQL1226N已经启动了最大数目的客户机连接。SQLSTATE=57030这个是什么原因，网上有说是 max_connections的原因可我采用的都是默认值打开的文件的最大总数(MAXTOTFILOP) = 16000现有代理进程的最大数目(MAXAGENTS) = 400协调代理程序的最大数目(MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)并发协调代理程序的最大数目(MAXCAGENTS) = MAX_COORDAGENTS客户机连接的最大数目(

[root@rac1 init.d]# ls /dev/oracleasm/disksVOL1----------原来还有 VOL2 ,VOL3 ,VOL4[root@rac1 init.d]# ./oracleasm scandisksScanning system for ASM disks: [OK][root@rac1 init.d]# ls /dev/oracleasm/disksVOL1[root@rac1 init.d]# ./oracleasm createdisk VOL3 /dev/sde1Marking disk "/dev/sde1" as an ASM disk: asmtool: Device "/dev/sde1" is already labeled for ASM disk ""[FAILED][root@rac1 init.d]# fdisk /dev/sdeCommand (m for help): pDisk /dev/sde: 1073 MB, 1073741

I was not able to Mount or Drop ASM disk group.SQL> select group_number, name, STATE from v$asm_diskgroup;GROUP_NUMBER NAME STATE------------ ------------------------------ -----------3 RAC_DATA1 DISMOUNTED4 RAC_DATA2 DISMOUNTED3 RAC_DG1 MOUNTED4 RAC_DG2 MOUNTEDSQL> drop diskgroup RAC_DATA1;drop diskgroup RAC_DATA1*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15001: diskgroup "RAC_DATA1" does not exist or is not mountedSQL> alter diskgroup RAC_DATA1

SQL> conn /as sysdbaConnected.SQL> select * from test.t;X-------------------------67SQL> select dbms_rowid.rowid_relative_fno(rowid),dbms_rowid.rowid_block_number(rowid) from test.t;DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)------------------------------------ ------------------------------------113254SQL> update test.t set x=x+

这个等待是原因引起的？附上statspac报告，各位帮分析下都存在哪些问题，即对应措施,谢谢！

RT

SQL> select namespace, gethitratio,pinhitratio,reloads,invalidations from v$librarycache;NAMESPACEGETHITRATIO PINHITRATIORELOADS INVALIDATIONS------------------------------ ----------- ----------- ---------- -------------SQL AREA.467185773.744976055161409196051TABLE/PROCEDURE1.00012774.999744325735070BODY.996973786.9795967647240TR

在Donald K.burleson《高性能SQL调整》有这样一段关于非关联子查询的开销 的话——非关联查询时子查询只会执行一次，而且结果是排序好的，并保存在一个ORACLE的临时段中，其中的每一个记录在返回时都会被父查询所引用。在子查询返回大量的记录的情况下，将这些结果集排序，以及将临时数据段进行排序会增加大量的系统开销。不是很理解，特别是红字部分，哪位解惑一下，谢谢！

在toad8.6里Run一个本地数据库中 简单的sp 老是抱ora-06550而同一个sp在pl/sql developer2000里是执行 是正常的 ，开始以为是 toad的问题， 可用toad Run其他的数据库的sp，却是正常的！这就奇怪了，难道我的数据库有问题？ 如果有问题，pl/sql developer2000 为什么又正常？

SQL> select * from t;XY---------- ----------01SQL> var idvariableiddatatypeNUMBERSQL> begin2:id:=0;3end;4/PL/SQL procedure successfully completed.SQL> print idID----------0SQL> begin2delete from t where x=:id;3end;4/PL/SQL procedure successfully completed.SQL> select * from t;no rows selectedSQL> rollback;Rollback complete.SQL> select * from t;X

有如下两张表：SQL> select * from s1;ID NAME---------- --------------------1 a2 b3 c4 dSQL> select * from s2;ID NAME---------- --------------------1 a2 b5 e我想得到如下的结果：SQL> select s1.name, s3.name from s1,(select * from s2 where s2.id=2 ) s3 wheres1.id=s3.id(+);NAMENAME-------------------- --------------------abbcd我将语

windows +oracle 9.2.0.6alter database open的时候碰到如下错误：SQL> alter database open;alter database open*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forced查看alert文件有如下提示：ORA-00704: bootstrap process failureORA-00604: error occurred at recursive SQL level 2ORA-08103: object no longer existsMon Mar 10 10:59:42 2008Error 704 happened during db open, shutting down databaseUSER: terminating instance due to error 704Mon Mar 10 1

RT

把安装目录删掉就可以吗？　

ERP 启动报错Setting service Oracle Discoverer services VIS_pmdb01 to mode 2Executing service control script:/u01/erp/appl/viscomn/admin/scripts/VIS_pmdb01/addisctl.sh startTimeout specified in context file: 300 second(s)script returned:****************************************************addisctl.sh version 115.14/u01/erp/appl/visora/8.0.6/vbroker/bin/osagentStarted osagent.Osagent logs messages to the file /u01/erp/appl/visora/8.0.6/discwb4/util/osagent.log.Waiting