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.

弱智

今天總算有機會上互聯(lián)網(wǎng)了，上面是輸入法問題，實在抱歉上面的話詞不達(dá)意，
望有相關(guān)經(jīng)驗的朋友聊聊。

謝謝lwlava的回復(fù)，你的方法已經(jīng)嘗試過了，還是會出ORA-04030錯誤。

lzfzl

http://72891.cn/viewthr ... highlight=ORA-04030

testuse

還是先給數(shù)據(jù)庫打個patch看看吧，其他的解決方法都不是根本上地解決方法。