I'd also look at sqlnet and DCD. Your connect time is exactly twice
your tcp timeout.

On 7/6/07, Jared Still <jkstill@(protected):
> On 7/3/07, Graham Ross <grahamaross@(protected):
> >
> > 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