Re: Long Time connecting to Database
Date: Mon, 29 Sep 2008 12:31:53 -0700
n Mon, Sep 22, 2008 at 6:55 AM, Bala <oratips_at_gmail.com> 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
> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 29 2008 - 14:31:53 CDT