Re: Oracle RAC

From: Kerry Osborne <kerry.osborne_at_enkitec.com>
Date: Wed, 1 Jul 2009 17:52:54 -0500
Message-Id: <4A0BD6D9-DDFD-4704-AF17-67D45BAD4ED0_at_enkitec.com>

Is pre_page_sga set to true by any chance? If so, try setting it to false.

Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com

On Jul 1, 2009, at 12:11 AM, Mohammed Mehraj Hussain 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 - 17:52:54 CDT