Re: Long Time connecting to Database
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- 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..
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
