RE: Disconnect from SQL*Plus takes more than 30 seconds
- From: "Thomas Biju" <BThomas@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Mar 2004 12:51:19 -0600
No triggers.
-----Original Message-----
From: Jay Hostetter [mailto:jhostetter@xxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, March 30, 2004 12:48 PM
To: Thomas Biju; oracle-l@xxxxxxxxxxxxx
Subject: Re: Disconnect from SQL*Plus takes more than 30 seconds
Any logoff triggers in this database?
Jay
>>> BThomas@xxxxxxxxxx 03/30/04 01:39PM >>>
Server Sun Solaris 2.8
Oracle8i 8.1.7.4
I have about 12 databases installed on the Oracle8i oracle home. One of the
database takes more than 30 seconds to disconnect from SQL*Plus,
when connected using SQL*Net. Connections using ORACLE_SID work fine, no
issues. Tried changing the host name to IP address in the
listener.ora and tsnames.ora files, but did not help. Any insight would be
highly appreciated. Please give me ideas to how to approach this
issue....
Thanks,
Biju Thomas
Database Administrator
_____________________________________________________________________________________________________________
This electronic transmission and any attached files are intended solely for the
person or entity to which they are addressed and may contain
information that is privileged, confidential or otherwise protected from
disclosure. Any review, retransmission, dissemination or other use,
including taking any action concerning this information by anyone other than
the named recipient, is strictly prohibited. If you are not the
intended recipient or have received this communication in error, please
immediately notify the sender and destroy this communication.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use
of the individual or entity to which they are addressed and
may contain information that is privileged, proprietary and confidential. If
you are not the intended recipient, you may not use, copy or
disclose to anyone the message or any information contained in the message. If
you have received this communication in error, please notify
the sender and delete this e-mail message. The contents do not represent the
opinion of D&E except to the extent that it relates to their
official business.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
_____________________________________________________________________________________________________________
This electronic transmission and any attached files are intended solely for the
person or entity to which they are addressed and may contain information that
is privileged, confidential or otherwise protected from disclosure. Any review,
retransmission, dissemination or other use, including taking any action
concerning this information by anyone other than the named recipient, is
strictly prohibited. If you are not the intended recipient or have received
this communication in error, please immediately notify the sender and destroy
this communication.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
