文章分类 -  oracle

摘要：http://xsb.itpub.net/post/419/53322select (length(str1) - nvl(length(replace(str1, str2)),0))/length(str2) from dual 阅读全文

摘要：Set "_disable_fast_aggregation"=true (This can be set at the session level or system wide)ORA-1467 Sort Key Too Long [ID 957805.1]Modified 10-JUN-2010Type PROBLEMStatus PUBLISHEDIn this DocumentSympto... 阅读全文

摘要：exp bjnoap/bjnoap@noap_61 direct=n recordlength=65535 buffer=50000000 file=exp_bjnoap_clt_pm.dmp log=exp_bjnoap_clt_pm.log tables=(clt_pm_eri%,clt_pm_sie%,clt_pm_zte_v2%,cfg_map_dev_to_ne) query=\"whe... 阅读全文

摘要：hb dxHP-UX，oracle10g rac asm节点2undo满，怀疑是这个原因。 阅读全文

摘要：数据库为非归档模式。SOLARIS 10 ORA10G ASM大体：RMAN> backup as copy datafile 5 format 'E:trans_tbsbakTEST.DBF';RMAN> SQL 'ALTER DATABASE DATAFILE 5 OFFLINE';RMAN> SWITCH DATAFILE 5 TO COPY;RMAN> RECOVE... 阅读全文

摘要：标记成功！ORA-29701 At Startup Of ASM Instance [ID 459775.1]http://blog.csdn.net/wyzxg/archive/2008/03/13/2176517.aspx2008/03/08skate今天配置asm遇到一个问题,在启动asm实例的时候提示:ORA-29701 :unable to connect to Cluster Mana... 阅读全文

摘要：查看oracle按安装目录使用100%，登陆进去开始删除无用的trace文件，以及audit文件。$ df -kFilesystem 1024-blocks Free %Used Iused %Iused Mounted on/dev/hd4 10485760 0 100% 46115 99% //dev/hd2 20971520 16020784 24% 87004 3% /usr/dev/hd... 阅读全文

摘要：http://space.itpub.net/?uid-55472-action-viewspace-itemid-4330021. enqueueEnqueues are local locks that serialize access to various resources. This wait eventindicates a wait for a lock that is held b... 阅读全文

摘要：http://space.itpub.net/?uid-55472-action-viewspace-itemid-432997 Common Wait EventsBuffer busy waits当一个session要获取buffer cache中的数据块，而该数据块正在被其他session所使用时这一event就会出现。两种情况下会产生这一事件：l另一Sesssion正在buffer cac... 阅读全文

摘要：Drop datafile in Oracle 10g引用：http://douqqwct.blog.163.com/blog/static/179167912008112753022331/In 9i database, the datafiles can't be dropped directly unless you will drop the whole tablespace. From ... 阅读全文

摘要：oracle网络配置三个配置文件 listener.ora、sqlnet.ora、tnsnames.ora ，都是放在$ORACLE_HOME\network\admin目录下。1. sqlnet.ora-----作用类似于linux或者其他unix的nsswitch.conf文件，通过这个文件来决定怎么样找一个连接中出现的连接字符串。例如我们客户端输入sqlplus sys/oracle@orc... 阅读全文

摘要：参考： http://neptune.javaeye.com/blog/165863参数如下两个网址:http://www.club.zj.com/viewthread.php?tid=1127180http://bbs.chinaunix.net/thread-1035512-1-1.html与网址1为准:现结合两个网址,写Oracle10g如果在RHEL5下安装:RHEL5 上 安装 Orac... 阅读全文

摘要：select sid, program ,machine from v$session where paddr in ( SELECT s.paddr FROM x$kglpn p, v$session s WHERE p.kglpnuse=s.saddr(+) AND p.kglpnmod <> 0 and kglpnhdl in ( select p1raw from v$sess... 阅读全文

摘要：最近碰到一个死锁的问题：ora-00060 deadlock detected while waiting for resource （ora-00060 等待资源时检测到死锁）查看udump（SQL> show parameter USER_DUMP_DEST; 查看该目录）下面的trace，发现如下日志：*** 2009-08-13 10:53:11.656*** SERVICE NAM... 阅读全文

摘要：create table test1(x int)partition by range(x)(partition x1 values less than (1),partition x2 values less than (10),partition x3 values less than (100));create table test2(x int)alter table test1 exch... 阅读全文