Re: Oracle RAC

  • From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
  • To: mhdmehraj@xxxxxxxxx
  • Date: Wed, 1 Jul 2009 17:52:54 -0500

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
  • References:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2009