ORA-00604:,ORA-04031: 引起的down机，谁能给分析一下！！！

biti_rainy

如果你配置了mts
1：mts配置你确信是正确的？
2：配置了mts，large_pool_size 必须加大，shared_pool_size 可减小

large_pool_size = 614400   改为150M
shared_pool_size = 253440000   可减少150M

biti_rainy

log_buffer = 5632000
改为最大3m就够了
再大没有任何意义

甚至，更小一点就ok了

wwmb

1704094 have been finded, but 1921561, 1193003 can't be finded.

oracle support ,不肯解决这个问题，说什么我们没有买这个linux 平台的服务，气死了。
to　chao_ping:   我的是oracle 8.1.7.0   ，redhat 7.2 , 请问加什么patch呀

jerrysun

8174  [BUG:2104071] ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS)

wwmb

有人这样解决，但是_db_handles_cached  不知道在那里？？

This bug exists in 8.1.7 only. If _db_handles_cached is non-zero (5 by
default) and you are seeing ORA-4031s and after setting _db_handles_cached to
0 the ORA-4031s stop, you may be running into this problem.



TO: cgh_chen愚惰者

在那里设置呀？？

STAR_TRANSFORMATION_ENABLED=FALSE

wwmb

最初由 jerrysun 发布
[B]8174  [BUG:2104071] ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS) [/B]

给个联接把，我的oracle 是8.1.7.0 的，

chao_ping

Where did you get this document?
To check whether that parameter is the default:
select name
  ,value
  ,decode(isdefault, 'TRUE','Y','N') as "Default"
    ,decode(ISEM,'TRUE','Y','N') as SesMod
    ,decode(ISYM,'IMMEDIATE', 'I',
    'DEFERRED', 'D',
    'FALSE', 'N') as SysMod
    ,decode(IMOD,'MODIFIED','U',
    'SYS_MODIFIED','S','N') as Modified
   ,decode(IADJ,'TRUE','Y','N') as Adjusted
   ,description
   from ( --GV$SYSTEM_PARAMETER
   select x.inst_id as instance
   ,x.indx+1
   ,ksppinm as name
   ,ksppity
   ,ksppstvl as value
   ,ksppstdf as isdefault
   ,decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE') as ISEM
   ,decode(bitand(ksppiflg/65536,3),
   1,'IMMEDIATE',2,'DEFERRED','FALSE') as ISYM
   ,decode(bitand(ksppstvf,7),1,'MODIFIED','FALSE') as IMOD
   ,decode(bitand(ksppstvf,2),2,'TRUE','FALSE') as IADJ
   ,ksppdesc as description
   from x$ksppi x
   ,x$ksppsv y
   where x.indx = y.indx
   and substr(ksppinm,1,1) = '_'
   and x.inst_id = USERENV('Instance')
   and ksppinm = '_db_handles_cached'
           )
   order by name

But be sure you met the exact situation as the document you refers to met.
Good luck

wwmb

x$ksppi ，x$ksppsv 这是什么表，怎么查不到呢？
你知道那个_db_handles_cached 试做什么用的吗？
chao_ping ,  给个patch 的联接吧，先试一试，你的看法，大个patch, 看看。

chao_ping

connect as internal and do the query.
To download patch, go to metalink , and click for patches.
For 8174 patchset:
ftp://updates.oracle.com/2376472/p2376472_8174_LINUX.zip

wwmb

谢谢，找到了，等我装完patch , 给你答复