Home » Developer & Programmer » Precompilers, OCI & OCCI » memory leak problem after oracle 8- 10g upgrade
memory leak problem after oracle 8- 10g upgrade [message #152677] Mon, 26 December 2005 06:01
sametkaradag
Messages: 1
Registered: December 2005
Junior Member
We upgraded Oracle 8i RAC database to Oracle RAC 10.1.0.3.0. After the
operation, i have encountered several problems (mainly performance problems)
and solved big amount by tuning and adding 2 GB RAMs to each node.
Now i have a problem about a ProC program that was working well before
upgrade. The program was working for nearly 1 hour and aborts by giving "out of
dynamic memory" and "Internal AIO consistency error: Cannot initialize aio
library." errors.
The first error log was:
KATM::210bkm:PAN:[6764010001498262]-processing code:[010000]-trans
amount:[000000001000]-STAN:[759041]-time:[212950]-date:[20051211]
-settlement date:[1212]-acq ID:[0000590000]-auth identification
resp:[967171]-resp code:[00]-term id:[02140070]-currency code:[949]-
Additional amount:[]
KATM::210:krdsw ye 210 aktarılıyor..
KATM::log_update:SQLSTR: UPDATE KK_200 SET
F038_PROV='967171',F039_RESPONCE='00' WHERE F002_PAN='6764010001498262' AND
F011_STAN='75
9041' AND F012_TIME='212950' AND F013_DATE='20051211' AND GELIS_YERI='A'
[1343272]Time : [Sun Dec 11 21:29:44.900173]
GIDEN:[02106764010001498262
01000000000000100075904121295020051211121200005900009671710002140070949

]

KATM:ATM den mesaj okundu...
KATM::WRN:Veri tabanı sql hatası oluştu ....

ORA-12154: TNS:could not resolve the connect identifier specified

in "..."
on line 492 of katmsrv.pc.

KATM::---------------------------------------------------------
KATM::message type:[0810]
[1342820]Time : [Sun Dec 11 21:29:45.155058]
[1342820]:Gelen:[29]-[08105245052129442005121100301]

KATM:810:STAN :[524505]-time :[212944]-date :[20051211]-resp code:[00]-net.
management inf. code:[301]
out of dynamic memory in yy_create_buffer()
KATM:ATM den mesaj okundu...
Internal AIO consistency error: Cannot initialize aio library.
Error 35: Operation would block
Aborting...
out of dynamic memory in yy_create_buffer()
KATM:bkm bağlantı kuruldu
out of dynamic memory in yy_create_buffer()
KATM:bkm bağlantı kuruldu
Internal AIO consistency error: Cannot initialize aio library.
Error 35: Operation would block
Aborting...



After an inspection we saw that the unix parameters; max_per_proc_data_size,
per_proc_data_size, max_per_proc_address_space and per_proc_address_space were
not configured according to the upgraded RAM, and changed them.
After changing the parameters "out of dynamic memory" errors were no more
seen, but the program now works for nearly 3 hours and aborts by giving the
;"Internal AIO consistency error: Cannot initialize aio library." error.
We realized that the program's memory usage increases during the execution,
and when there remains no more free space, program aborts. The problem seem to
be caused by the program's memory usage. But the program was working with no
problem before upgrade.
The upgraded
parameters:
BEFORE:
per_proc_data_size=320M
max_per_proc_data_size=1073741824
max_per_proc_address_space=2147483648
per_proc_address_space=2147483648
shm_max=2000000000
AFTER:
per_proc_data_size=1073741824
max_per_proc_data_size=2147483648
max_per_proc_address_space=4294967296
per_proc_address_space=4294967296
shm_max=4000000000
THE ERROR (AFTER PARAMETER CHANGE):
Internal AIO consistency error: Cannot initialize aio library.
Error 35: Operation would block
Aborting...
Internal AIO consistency error: Cannot initialize aio library.
Error 35: Operation would block
Aborting...


Thanks,
Samet Karadağ
Previous Topic: How can I pass more than one user defined objects from C++ to oracle stored procedure
Next Topic: How to call one Proc program from another
Goto Forum:
  


Current Time: Fri Mar 29 04:33:55 CDT 2024