Re: Long Time connecting to Database

n Mon, Sep 22, 2008 at 6:55 AM, Bala <oratips@xxxxxxxxx> 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/ 10.2.0.4
>
>

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.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: