Re: Oracle RAC

From: Mohammed Mehraj Hussain <mhdmehraj_at_gmail.com>
Date: Thu, 2 Jul 2009 10:11:34 +0530
Message-ID: <b081c0a50907012141t1113064av7c399e4bc0696a86_at_mail.gmail.com>

pre_page_sga is set to false only , but still having the same issue

On Thu, Jul 2, 2009 at 4:22 AM, Kerry Osborne <kerry.osborne_at_enkitec.com>wrote:

> 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 - 23:41:34 CDT