ITPub博客

环境：OS：linuxDB：10.2.0.4引子：最近的数据库时不时的报临时表空间的满的警告，后来跟踪代码，发现是做CLOB操作时，导致的。测试代码：先建一个临时表空间，文件大小为100M， 开三个session, 依次在每个session里跑下面的代码：declareclb clob;ch varchar2(32767);k number;begindbms_lob.createtemporary(clb,true,dbms_lob.call);for i in 1..1500 loopch:=lpad('o',32767,'Y');dbms_lob.writeappend(clb,length(ch),ch);end loop;k:=dbms_lob.getlength(clb);dbms_lob.freetemporary(clb);dbms_output.put_line('the clob length:

前一段时间碰到的问题.环境：ＤＢ：Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64biＯＳ　SunOS 5.10 Generic_127111-11 sun4u sparc SUNW,Netra-T12具体的错误：ORA-00600: internal error code, arguments: [17059], [0x4468DA9C8], [], [], [], [], [], []处理：从alert 文件里找到相应的trace文件, trace文件的内容：LIBRARY OBJECT HANDLE: handle=48af69c08 mtx=48af69d38(0) cdp=237name=把错误时执行的SQLhash=5a6bb2113c18cd8df5bb3c573f18f594 timestamp=02-14-2009 17:20:24namespace=CRSR flags=RON/KGHP/

Streams configuration step by stepStreams is a new way to duplicate data. Normally, we have the Streams to duplicate data from one database to another database; we can also have the data duplication with Stream technology within one database, Here, I will give an example to do Streams configuration in a database to duplicate data from one schema (TEST1) to another schema (TEST2).Environments:OS: Linux version 2.6.9-67.ELsmpOracle: Oracle Database 10g Enterprise Edition Release 10.2.0.4.01, Overv