RE: Disconnect from SQL*Plus takes more than 30 seconds

From: John Hallas <john.hallas_at_hcresources.co.uk>
Date: Tue, 30 Mar 2004 22:13:38 +0100
Message-ID: <MCBBKANEJCHPBLJNAGGOGECKCIAA.john.hallas@hcresources.co.uk>

Well done fixing your problem. I find if you truncate a few tables, queries run so much faster as well. :)

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thomas Biju
Sent: 30 March 2004 20:54
To: oracle-l_at_freelists.org
Subject: RE: Disconnect from SQL*Plus takes more than 30 seconds

Thank you all. I truncated the AUD$ table (it was huge 550MB!!) and now the logon and logoff work really good.

Thanks,
Biju

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, March 30, 2004 1:01 PM
To: oracle-l_at_freelists.org
Subject: RE: Disconnect from SQL*Plus takes more than 30 seconds

Any log-off auditing??

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Biju Sent: Tuesday, March 30, 2004 1:51 PM
To: oracle-l_at_freelists.org
Subject: RE: Disconnect from SQL*Plus takes more than 30 seconds

No triggers.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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

---

Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/04

---

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/04

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Mar 30 2004 - 15:11:49 CST