If a problem occurs in PITSS.CON where it appears to hang or freeze, some updates to the database environment may be required. The following steps may be run to fix any PITSS.CON hung sessions:
- On the database server, using the unix prompt logged in as oracle: ulimit -a (we are looking for max user processes) ps -eaf|grep LOCAL|wc -l (this will tell us the number of database connection processes) more /etc/sysctl.conf (check the kernel.sem or semaphores)
- From sqlplus connected as sys: show parameter sessions (formula is processes*1.1 eg, 500*1.1=550) show parameter processes (number of OS processes allowed +5 for background processes)
- Make sure that the database listener does not have the “queuesize” set.