weejar zhang – Page 61

ora-02069 global_names=false

2011-12-05 by weejar zhang

when you try to access a table over the database link,mybe you get this error

Troubleshooting wait event :cursor: pin S wait on X

2022-01-132011-11-30 by weejar zhang

从oracle10g(10.2.0.2)开始，开始启用mutex来替换以前的library cache bin latch，这是一种os级更低层的轻量级锁，但是也不是那么完美，有时会出现events cursor: pin S wait on X

ASMLib and OCFS2在RHEL6不再免费支持

2011-11-29 by weejar zhang

Doc ID 1089399.1: ”For RHEL6 Oracle will only provide ASMLib software and updates via Unbreakable Linux Network(ULN). Oracle will no longer provide ASMLib packages for Red Hat kernels.”

How do you know empty block? dump block

2013-11-012011-11-28 by weejar zhang

看老白日记中有一个案例提到有一个select from where rownum<10的查询要很长时间，后来做了block dump断定是碎片，但是dump出来的内容是如何判断都是空块的呢？

bulk collect 会不会引发not data found?

2011-11-23 by weejar zhang

The FETCH statement never raises a NO_DATA_FOUND exception as it is anticipated that it will eventually hit this condition ,Because the processing of the BULK COLLECT INTO clause is similar to a FETCH loop

alter table move 遭遇ORA-01652: unable to extend temp segment

2011-11-16 by weejar zhang

anbob@ORCL> alter table testspace move tablespace anbob;
alter table testspace move tablespace anbob
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace ANBOB

truncate table 会不会释放datafile的空间？如何才能释放?

2011-11-16 by weejar zhang

下面我将做一这一实验来证明 oracle 10g r2 system@ORCL> create tablespace anbob datafile ‘/u01/app/oracle/oradata/ORCL/datafile/anbob.dbf’ size 40m; Tablespace created. anbob@ORCL> create table testspace as select * from all_objects; Table created. anbob@ORCL> select segment_name,tablespace_name from user_segments where segment_name=’TESTSPACE’; SEGMENT_NAME TABLESPACE_NAME ——————– ——————– TESTSPACE TT anbob@ORCL> select count(*) from testspace; COUNT(*) ———- 40770 anbob@ORCL> insert into testspace select * from testspace; 40770 … Read more

安装gc遭遇oui-25031 web cache configuration assistant faild!

2011-11-16 by weejar zhang

环境linux rhel 5 , grid constol 102011 问题 oui-25031:some of the configuration assistants failed. 窗口确认后发现是web cache configuration assistant faild! 原因 OEM (10.2.0.1) on RHEL5 is not supported please check the certification from metalink 解决%E

ORA-01877: string is too long for internal buffer 排查

2011-11-112011-11-11 by weejar zhang

SQL> select BUILD_DATE,dump(build_date) from jmjk_jilin_th_mhk.ehealth_arch_basicinfo where BUILD_DATe>sysdate
2 ;
ERROR:
ORA-01877: string is too long for internal buffer