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 > > >