Re: Very slow sqlplus connect with 10G

From: Jumbo <cool11_at_net.hr>
Date: Mon, 6 Mar 2006 20:44:15 +0100
Message-ID: <dui3ed$peq$1@ss405.t-com.hr>

<admin_at_loial.co.uk> wrote in message
news:1141673852.309633.161320_at_i40g2000cwc.googlegroups.com...
> Have just installed Oracle 10G R2 on fedora linux box with 1 GB memory.
>
> It is VERY slow, i.e 15 seconds to connect with sqlplus from the linux
> command line.
>
> Where do I start to find out why this is happening?

Is the connection over SQL*Net (@database) or is the ORACLE_SID set in the environment?

Try to trace the listener and check your UDUMP directory for trace files. Received on Mon Mar 06 2006 - 13:44:15 CST