ORA-04030 ERROR

弱智

Hi, i'm very sorry for typing English, this Chinese input method cannot work properly now.

I often encounter this error message: ORA-04030, I can not resolve this issue completely.
Surf the net to search the solution, but their answer are all the same: tuning the memory using (SGA, PGA): decrease the amount of the memory requirement.

Now the AIX BOX i'm using have the 16G main memory, the main table has 66000K rows, and using the raw devices to optimize the performance.

But when running some sort or hashing statements, this error take places, thus these statements failure and the weblogic or websphere can not output the correct query result for end users.

AIX version: 5.3L
Oracle version: 9.2.0.1, 64 bits version

How can I solve this issue completely?

thanks for any advices.

lwlava

Please increased shared_pool_size

弱智

My friend tell me: It must be the "oracel bug", only to upgrade oracle to version 9.2.0.4 or above can solve it.

but now i have no perfect enviornment for this update.....  

弱智

thanx for reply

but now oracle uses only 5% capacity of the  shared pool ( by using TOAD's DBA monitor function)



the init paramenters in my pfile shows as below:
db_cache_size=8000M
sga_max_size=9800M
shared_pool_size=800M
pga_arrgregate_size=2500M

may be I should increase the value of parameter sga_max_size ?

[ 本帖最后由 弱智 于 2006-5-26 16:44 编辑 ]

lwlava

try,try!

弱智

now the almost all the hit ratio of in the library cahe and dictionary cache are 99%,
why to increase this value?

弱智

now I can not connect to the database,  because the aix box is in the intranet, not link to the Internet. the snapshoot of "topas" command in AIX will be pasted here if nesseray.

弱智

今天总算有机会上互联网了，上面是输入法问题，实在抱歉上面的话词不达意，
望有相关经验的朋友聊聊。

谢谢lwlava的回复，你的方法已经尝试过了，还是会出ORA-04030错误。

lzfzl

http://bbs.chinaunix.net/viewthr ... highlight=ORA-04030

testuse

还是先给数据库打个patch看看吧，其他的解决方法都不是根本上地解决方法。