Thanks for the question, Stanislav.
Asked: October 25, 2017 - 8:10 am UTC
Last updated: October 26, 2017 - 1:32 am UTC
Version: Oracle database server 12C
Viewed 10K+ times! This question is
You Asked
Hello;
could you help me with problem of memory, I try describe it.
I have application under tomcat on application server, application generates select to
database server, after few secconds application logs error
ORA-27103: internal error
Additional information: 11818
Additional information: 9
ORA-27102: out of memory
IBM AIX RISC System/6000 Error: 12: Not enough space
Additional information: 6628
Additional information: 16777216
I search what is out of space, but cannot find. Discs spaces is OK, swap is OK, temp spaces is OK,
( on applic. and database servers ), user has no limits in AIX, I try monitor SGA and PGA,
tempfiles in oracle but I find no such consumption.
Could you direct me what I have to monitor during executing this select to see what of source will be lost ?
What does it mean "Additional information" in error message ?
Very thank you.
Hricko Stanislav
and Connor said...
Some things to check
Real memory for this machine (or lpar)
/usr/sbin/lsattr -HE -l sys0 -a realmem
Swap allocation
/usr/sbin/lsps -a
You have sufficient *shared* memory allocated
ipcs -a
Make sure ORACLE_SGA_PGSZ is not set in either profile or explicitly.
Also, MOS note 169706.1 has an excellent checklist of all the things to ensure your database server environment is configured correctly.
Hope this helps
Is this answer out of date? If it is, please let us know via a Comment