On 7/3/07, Graham Ross <grahamaross@xxxxxxxxx> 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