Hi,
You can check v$session, there is a column called SERVER wher you can find that what type of connection is being used.
Hope this helps;
Gilson
----- Original Message -----
From: nagarajanv <oracledba-ezmlmshield-x97565234.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: RE: Application performance issue
Date: Fri, 29 Apr 2005 19:51:01 +0530
>
>
> 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.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
Oracle LazyDBA home page