Re: Long Time connecting to Database

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..

Cheers
Riyaj
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
> appreciated.
>
> 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
>

--
http://www.freelists.org/webpage/oracle-l