I'd also look at sqlnet and DCD. Your connect time is exactly twice
your tcp timeout.
On 7/6/07, Jared Still <jkstill_at_gmail.com> wrote:
> On 7/3/07, Graham Ross <grahamaross_at_yahoo.com> wrote:
> >
> > All,
> >
> > I can't help thinking that there is some process trying to start and
> > failing, and I can't for the life of me think of what it could be. I
> > expect it's something blindingly obvious, but I'd be delighted to hear any
> > suggestions.
> >
> >
>
> Check for login.sql in the SQLPATH, and take a look at
> $ORACLE_HOME/sqlplus/admin/glogin.sql
>
> Also login as DBA and run the following while logging in from another
> window.
> You may see some waits if the problem is local to the database.
>
> select
> s.username username,
> e.event event,
> s.sid,
> e.p1text,
> e.p1,
> e.p2text,
> e.p2,
> e.wait_time,
> e.seconds_in_wait,
> e.state
> from v$session s, v$session_wait e
> where s.username is not null
> and s.sid = e.sid
> order by s.username, upper(e.event)
> /
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 06 2007 - 13:53:32 CDT
