Re: Long Time connecting to Database
Date: Mon, 29 Sep 2008 15:03:33 -0500
For HPUX- it is tusc
For some hpux versions, you may need to download tusc and run it as user.
But, 8 minutes is quite long time.. Is there any logon triggers?
Can you collect statspack or AWR report for those 8 minutes? and post top 5 timed event here? It is a possibility that other database misconfiguration causing this issue too..
The Pythian Group.
blog : http://orainternals.wordpress.com
Jared Still wrote:
> n Mon, Sep 22, 2008 at 6:55 AM, Bala <oratips_at_gmail.com
> <mailto: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 <http://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