Thanks for your reply. Oracle Connections are getting created from Weblogic application Server. How to identify whether connection is shared or dedicated?. All Inactive Oracle sessions are mapped to AIX process and each one is holding around 20 MB. Is their any way to release/reduce the memory of Inactive sessions?

Thanks & Regards
Nagarajan

-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x98245200.[Email address protected]
Sent: Thursday, April 28, 2005 10:34 PM
To: LazyDBA Discussion
Subject: RE: Application performance issue


Your buffer cache is set to ONLY 64m??? With all that ram you ought to at least have between 1 and 2GB to start with. You need to less physical I/O and a lot more LOGICAL. With that kind or memory, you might be able to go a lot further with both shared pool and buffer cache. Depends on how many users, whether you are running MTS vs dedicated connections, etc...



DISCLAIMER:

Information transmitted by this e-mail may be proprietary to Ramco Systems Ltd., and / or the authors of the information and is intended for use only by the individual or entity to which it is addressed, and may contain confidential or legally privileged information. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are not authorised to access, read, disclose, copy, use or otherwise deal with it and any such actions are prohibited and may be unlawful.

Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. Ramco Systems Limited therefore does not accept liability for any errors, omissions, viruses or computer problems experienced as a result of this transmission.

If you have received this e-mail in error, please notify us immediately at mail to: [Email address protected] and delete this mail from your records. Notice is hereby given that no representation, contract or other binding obligation shall be created by this e-mail.

Oracle LazyDBA home page