星期五, 11月 25, 2011

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.

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...