ANBOB™

操作已加载到内存中的数据时所需要的工作区域，这块内存区对于每个服务器进程都是私有的，不允许其它进程或线程的访问，PGA 一般是通过C 语言在运行时调用malloc() 和memmap() 来分配的，运行时可以动态的扩大，在8i后甚至可以动态的收缩，…

SQL> shutdown immediate
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00600: 内部错误代码，参数: [kspgsp1], [101], [642], [1], [optimizer_mode], [], [], []

[oracle@anbob agent10g]$ bin/emctl upload agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

前一篇提到AGENT的多种安装方式中，如果平台一致最容易的安装方法就是使用agentDownload.linux

grid control （网格）管理 多个数据库时可以大大提高DBA 的工作效率，当然也有人说会给系统带来一些影响比如引起BUG，从而望而却步，不过ORACLE的 不断的完善还是很让人期待

今天有网友说他的数据库服务今天又自动停了，以前也说过查看alert日志并没报错，stackpack也看不出什么 […]

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.

OPMN is Oracle Application Server’s Process Monitor and Notification server. Use this utility to stop, start and get process status.

当系统中有很多索引或一个表上有很多索引，想找出平时不用的索引drop 掉，因为索引毕竟会给insert/update 等带来负担，于时ORACLE提供了monitoring index的功能， 但有时一些情况会被忽略，正面看我的实验

一个在windows下解压的oracle10 for linux安装文件，传到rhel 5安装遭遇 database/install/.oui: Permission denied 权限问题

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

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

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.”

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

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

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

下面我将做一这一实验来证明 oracle 10g r2 system@ORCL> create tablesp […]

环境linux rhel 5 , grid constol 102011 问题 oui-25031:some […]

时间过的真快，马上又一年，感觉好累好累…

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