Hi Andrew, If you meant this 13443029 bug. Oracle support tell us that "this Bug 13443029 is fixed in 11.2.0.4 and since you are already on AIX 7.1 TL03 SP01 your issue is a different issue." thanks *-----------------* *Tiran* *Best RegardsStay in touch...* On 24 June 2014 15:37, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > There is an oracle bug that causes this, I ran into recently. I will see > if I can find the number. > > > On Tue, Jun 24, 2014 at 8:04 AM, Deas, Scott <Scott.Deas@xxxxxxx> wrote: > >> Tiran, >> >> >> >> Maybe I’m misreading your lsps output, but it doesn’t look like your swap >> space is actually being utilized (unless that output is from a time when >> the database is not running). >> >> >> >> Have you reviewed the documentation from Oracle for installing 11.2 on >> AIX, specifically, I’m wondering if your oracle user has access to the >> memory that’s been allocated on the system - >> http://docs.oracle.com/cd/E11882_01/install.112/e48740/pre_install.htm#AXDBI1184. >> We have had issues where the ulimit has not been set correctly, but we did >> not see the exact issue you’re describing. Here’s a doc from IBM on >> checking the ulimit values: >> http://publib.boulder.ibm.com/tividd/td/ITAME/SC32-1351-00/en_US/HTML/am51_perftune35.htm. >> >> >> >> >> Also, could you verify with nmon that the system is actually swapping, >> and that it’s not just the database that’s perceiving this issue? >> >> >> >> Thanks, >> Scott >> >> >> >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Outsider >> *Sent:* Tuesday, June 24, 2014 6:23 AM >> *To:* Oracle L >> *Subject:* Oracle AIX problem >> >> >> >> Hi Oracle - AIX experts, >> >> >> >> I am in very difficult situation. We have AIX 7.1 TL3SP1 server in >> PureFlex hardware. On this AIX we have Oracle DB 11.2.0.4.0. DB works as >> expected after startup and suddenly it goes crazy. No one can connect to >> this DB from application and there is a lot of error in alert log and also >> in AIX. So this is heavy swapping problem which I had previously in Oracle >> Linux , in that case we added memory and swap[ file also we had problem >> with low disks (actually the problem was problematic disks). Here we have >> 8G memory and 16G page space and disks also OK. The only thing in which I >> am not sure the configuration of page spaces. But I am not AIX >> specialist.... >> >> >> >> Please who have same experience with this , please advise how can we >> solve this. >> >> >> >> root@sgp-podb201a/ # lsps -a >> >> Page Space Physical Volume Volume Group Size %Used Active Auto >> Type Chksum >> >> paging01 hdisk6 vg01 8192MB >> 1 yes yes lv 0 >> >> paging00 hdisk1 vg01 8192MB >> 4 yes yes lv 0 >> >> hd6 hdisk0 rootvg 512MB >> 0 no no lv 0 >> >> >> >> Info >> >> MEMORY >> >> Real,MB 8192 >> >> % Comp 64 >> >> % Noncomp 16 >> >> % Client 16 >> >> >> >> PAGING SPACE >> >> Size,MB 16384 >> >> % Used 2 >> >> % Free 98 >> >> >> >> PAGING >> >> Faults 25 >> >> Steals 0 >> >> PgspIn 0 >> >> PgspOut 0 >> >> PageIn 0 >> >> PageOut 15 >> >> Sios 15 >> >> >> >> Alert log >> >> >> >> Tue Jun 24 08:20:32 2014 >> >> WARNING: Heavy swapping observed on system in last 5 mins. >> >> pct of memory swapped in [359.98%] pct of memory swapped out [0.87%]. >> >> Please make sure there is no memory pressure and the SGA and PGA >> >> are configured correctly. Look at DBRM trace file for more details. >> >> Tue Jun 24 08:37:52 2014 >> >> Emon ping encountered error 4021 >> >> Errors in file >> /opt/oracle/diag/rdbms/shpsgpp1dg1/SHPSGPP1/trace/SHPSGPP1_q000_20185316.trc: >> >> ORA-04021: timeout occurred while waiting to lock object >> >> Tue Jun 24 09:00:53 2014 >> >> Emon ping encountered error 4021 >> >> ******* >> >> ORA-04021: timeout occurred while waiting to lock object >> >> Tue Jun 24 12:35:16 2014 >> >> Emon timeout encountered error 4021 >> >> Tue Jun 24 12:35:16 2014 >> >> Emon timeout encountered error 4021 >> >> ********** >> >> >> >> Oracle trace file >> >> >> >> *** 2014-06-24 13:13:31.648 >> >> *** SESSION ID:(478.11) 2014-06-24 13:13:31.648 >> >> *** CLIENT ID:() 2014-06-24 13:13:31.648 >> >> *** SERVICE NAME:(SYS$BACKGROUND) 2014-06-24 13:13:31.648 >> >> *** MODULE NAME:(Streams) 2014-06-24 13:13:31.648 >> >> *** ACTION NAME:(QMON Slave) 2014-06-24 13:13:31.648 >> >> >> >> KSV 4021 error in slave process >> >> >> >> *** 2014-06-24 13:13:31.648 >> >> ORA-04021: timeout occurred while waiting to lock object >> >> OPIRIP: Uncaught error 447. Error stack: >> >> ORA-00447: fatal error in background process >> >> ORA-04021: timeout occurred while waiting to lock object >> >> >> >> >> >> Thanks in advance. >> >> >> >> >> >> *-----------------* >> >> *Tiran* >> >> >> *Best Regards Stay in touch...* >> >> Notice of Confidentiality: **This E-mail and any of its attachments may >> contain >> Lincoln National Corporation proprietary information, which is >> privileged, confidential, >> or subject to copyright belonging to the Lincoln National Corporation >> family of >> companies. This E-mail is intended solely for the use of the individual >> or entity to >> which it is addressed. If you are not the intended recipient of this >> E-mail, you are >> hereby notified that any dissemination, distribution, copying, or action >> taken in >> relation to the contents of and attachments to this E-mail is strictly >> prohibited >> and may be unlawful. If you have received this E-mail in error, please >> notify the >> sender immediately and permanently delete the original and any copy of >> this E-mail >> and any printout. Thank You.** >> > > > > -- > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' >