RE: DATABASE DISCONNECT ON AIX

From: Guang Mei <gmei_at_incyte.com>
Date: Mon, 8 Nov 2004 12:18:35 -0500
Message-ID: <NJEDKDKJDGAKAEKKNEEJCEHPDMAA.gmei@incyte.com>

Does the problem occur only to a particular application user name? Does the problem occur only on a partuclar client machine?

Some possibilities:

1. Bad network
2. DB has a profile that limits user connection time, this means user will be disconnted from DB automatically after certain idle time.
3. Unlikely, but does the application has a "time-out" feature?

Guang

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: Monday, November 08, 2004 11:57 AM To: oracle-l_at_freelists.org
Subject: DATABASE DISCONNECT ON AIX

Hi,
One of client are running oracle817 on AIX5 with perl and apache.Time to time we have been noticing "DATABASE DISCONNECT" issue with applictaion.the ping,tnsping looks ok between applictaion box and DB box.I only seen less SGA and couple of performance issue like memory leakage and 80 to 100mb memory free.the SGA allocated to 170mb which is I'm thinking is less. What could be reason?
any suggestions and thoughts are welcome. thanks
-Seema

---

Get ready for school! Find articles, homework help and more in the Back to School Guide! http://special.msn.com/network/04backtoschool.armx

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 08 2004 - 11:14:21 CST