Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql*plus connect times

sql*plus connect times

From: Charles Hansis <chansis_at_earthlink.net>
Date: Fri, 24 Sep 1999 22:06:41 -0400
Message-ID: <7shaif$q6d$1@birch.prod.itd.earthlink.net>


I have a 7.3.2 database with 6 instances on it. (HP9000-T520 4 Proc and 2 g RAM) and we are experiencing a extreme delay while trying to connect to sql*plus during the "high activity time" in the mornings. We have tried using mts and didn't find it making any improvements in performance, also added parms in listener.ora to prespawn processes with no noticeable results, so I come to the well of knowledge seeking advice on how improve my situation.

Thanks,

Jim H. Received on Fri Sep 24 1999 - 21:06:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US