Oracle 9i rac GES

GES

Global Enqueue Service (GES)

This service coordinates local and global enqueues.

http://www.oracle.co.jp/forum/thread.jspa?threadID=3002652

>WARNING: ran out of shared pool for GES enqueue object.

>WARNING: ran out of shared pool for GES enqueue object.

>WARNING: ran out of shared pool for GES enqueue object.

>WARNING: ran out of shared pool for GES enqueue object.

>WARNING: ran out of shared pool for GES enqueue object.

>WARNING: ran out of shared pool for GES enqueue object.

>WARNING: ran out of shared pool for GES enqueue object.

gv$ges_enqueue

提到shared_pool不足的可能性比較高,是RAC本來就有的問題
如果想更深入的了解enqueue hash,resource和lock，可以dump出具体的结果看看：

alter session set events ’immediate trace name enqueues level 3’;

-

9207 rac下有一個經典的bug.

一直報ORA-04031

不知道你的情況是如何.

v$resource_limit

-

select * from v$sgastat where name like '%free%';

关注下shared pool   free memory的变化:

POOL                     NAME                                          BYTES

------------------------ ---------------------------------------- ----------

shared pool              ksuloi: long op free list                       256

shared pool              message pool freequeue                       757568

shared pool              kghx free lists                               49952

shared pool              free memory                                87922920

shared pool              kglsim free obj list                            408

shared pool              sim kghx free lists                               8

shared pool              kglsim free heap list                           408

java pool                free memory                                27998336

streams pool             free memory                                67108864

-

ALTER SYSTEM FLUSH SHARED POOL.