Re: Oracle RAC
- From: Ashwin <ashdbablog@xxxxxxxxx>
- To: kerry.osborne@xxxxxxxxxxx
- Date: Wed, 1 Jul 2009 17:59:08 -0700
Try setting a higher value of pga_aggregate_target and check.
Regards,
Ashwin
On Wed, Jul 1, 2009 at 3:52 PM, Kerry Osborne <kerry.osborne@xxxxxxxxxxx>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 ...
>>
>>
>>
>>
>>
>>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
