Re: App Dev Question: To logoff or stay connected?

On Fri, 22 May 1998 07:34:51 -0500, michael twaddell TWA <175501_at_dallas.dseg.ti.com> wrote:
>We have a number of client-server applications that access Oracle
>to store and retrieve data, but are probably only active around 5%
>of the time, at the most. Most of the time is spent viewing/analyzing
>the data, or the application may just be sitting idle. My dilemma is
>whether or not to have the applications logon each time they wish to
>perform an Oracle transaction, and then logoff once the transaction is
>completed. We currently have both types of applications.
>

<snip>
>
>What are the opinions of the Developers and DBAs on this newsgroup? My
>preference, as a DBA and Developer, is to logon and logoff for each
>Oracle
>transaction, but that view is not shared by everybody. Thanks in
>advance
>for your responses.

Do it your way, tell people it raises the effective capacity of the machine.

>
>--
>Michael Twaddell
>Raytheon Systems
>twaddell_at_ti.com

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.