Re: Oracle RAC

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Wed, 1 Jul 2009 08:03:49 +0200
Message-ID: <8580d4110906302303o50a30d9enac501a55aaa85ae8_at_mail.gmail.com>

You have to figure out what it i that takes the time. Do you have a login/glogin file that may be executed? Do you have a login trigger?

Does it take as long if you connect from sql Developer or any other tool than sql plus. Does it take as long from other PCs? Does it take as long for a local connect? If you connect directly to a node, does it take the same time?

Mathias

On Wed, Jul 1, 2009 at 7:11 AM, Mohammed Mehraj Hussain <mhdmehraj_at_gmail.com
> wrote:

> HI ,
>
> i have a 2-node oracle 10g rac on win 2003 server , when i connects to the
> database it takes around 15 -20 seconds to connect , is there any way to
> make it faster ,
>
> for eg :
>
> set ORACLE_SID=RAC1
> D:\>SQLPLUS / as sysdba
>
> SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jul 1 10:40:05 2009
>
> Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
> With the Partitioning, Real Application Clusters, OLAP, Data Mining
> and Real Application Testing options
>
> SQL>*it takes me 20 seconds to get this sql prompt ...*
> **
> **
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 01 2009 - 01:03:49 CDT