GC OMS is not functioning because of the following reason:Connection to the repository failed.
Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.Oracle Management Server is not functioning because of the following reason:Connection to the repository failed. Verify that the repository connection information provided is correct.
what is oracle opmn?opmnctl
OPMN is Oracle Application Server’s Process Monitor and Notification server. Use this utility to stop, start and get process status.
index monitoring usage 注意了！
当系统中有很多索引或一个表上有很多索引，想找出平时不用的索引drop 掉，因为索引毕竟会给insert/update 等带来负担，于时ORACLE提供了monitoring index的功能， 但有时一些情况会被忽略，正面看我的实验
redhat linux ./runInstaller 遭遇 database/install/.oui: Permission denied
一个在windows下解压的oracle10 for linux安装文件，传到rhel 5安装遭遇 database/install/.oui: Permission denied 权限问题
ora-02069 global_names=false
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
从oracle10g(10.2.0.2)开始 ，开始启用mutex来替换以前的library cache bin latch，这是一种os级更低层的轻量级锁，但是也不是那么完美，有时会出现events cursor: pin S wait on X
ASMLib and OCFS2在RHEL6不再免费支持
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
看老白日记中有一个案例提到有一个select from where rownum<10的查询要很长时间，后来做了block dump断定是碎片，但是dump出来的内容是如何判断都是空块的呢？
bulk collect 会不会引发not data found?
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
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的空间？如何才能释放?
下面我将做一这一实验来证明 oracle 10g r2 system@ORCL> create tablesp […]
安装gc遭遇oui-25031 web cache configuration assistant faild!
环境linux rhel 5 , grid constol 102011 问题 oui-25031:some […]
ORA-01877: string is too long for internal buffer 排查
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
What is “save undo”?
save undo is undo saved for offlined tablespaces. It is also known as deferred rollback
如何看待sql执行计划里的cost
cost 内部记算方法oracle也不会公开，oracle内部用来比较各个执行计划所耗费的代价的值，从而使优化器可以选择最好的执行计划。不同语句的cost值不具有可比性，只能对同一个语句的不同执行计划的cost值进行比较。
