Re: Long Time connecting to Database

From: Pete Finnigan <>
Date: Fri, 03 Oct 2008 09:24:47 +0100
Message-ID: <>

Hi Jared,

You should be wary (if that's the right spelling) of using sqlnet trace at SUPPORT or level 16 as it can include data that can be used to connect to the database without a password.

Ensure that you collect the SUPPORT level trace on a client and not the server if possible and ideally delete the trace afterwards.



Jared Still wrote:
> n Mon, Sep 22, 2008 at 6:55 AM, Bala <> wrote:

>> Connecting to 10g Database from -- sqlplus/front end application/ or
>> locally as sysdba -- is taking a very long time -- upto 8 mts.
>> How do i troubleshoot this issue ? Any help or insight is highly
>> appreciated.
>> Unix -- HP Unix 11.31/

> Is there an HPUX equivalent to strace(linux) or truss(solaris)?
> That might be a good place to start.
> You could also enable advanced SQL Net tracing to see if anything turns up
> there.
> Successful interpretation of the resultant Net trace files may require an
> SR.

Pete Finnigan
Principal Consultant Limited

Registered in England and Wales
Company No: 4664901

Specialists in database security.

If you need help to audit or secure an Oracle database, please ask for
details of our courses and consulting services

Phone: 0044 (0)1904 791188
Fax  : 0044 (0)1904 791188
Mob  : 0044 (0)7742 114223
site :

Please note that this email communication is intended only for the
addressee and may contain confidential or privileged information. The
contents of this email may be circulated internally within your
organisation only and may not be communicated to third parties without
the prior written permission of Limited.  This email is
not intended nor should it be taken to create any legal relations,
contractual or otherwise.

Received on Fri Oct 03 2008 - 03:24:47 CDT

Original text of this message