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@xxxxxxxxx <mailto: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 <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

Other related posts: