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 -> Re: how to reduce login time?

Re: how to reduce login time?

From: koert54 <koert54_at_nospam.com>
Date: Wed, 31 Oct 2001 19:33:21 GMT
Message-ID: <5mYD7.1511$G43.134@afrodite.telenet-ops.be>


You could configure pre-spawned servers in listener.ora - however this is not possible on NT platforms and I think they won't be supported anymore in Oracle 9i
You could also use MTS - this way the listener won't have to spawned the Oracle executable - it'll redirect the request to one of the dispatchers ... You might want to check some things :

1. traffic network ?
2. I/O on disk containing oracle binanries ?
3. too many processes already running - high runqueue - heavy paging ? ->
MTS "Hello_World" <nix1_at_cuse15.se.cuhk.edu.hk> wrote in message news:9rpfgu$rfd$1_at_eng-ser1.erg.cuhk.edu.hk...
> I find that the time taken to login through sqlplus and JDBC in program is
> long. It takes about few seconds.
> I want users can login immediately if he/she has enterd correct username
> and password.
>
> How can I minimize the login time?
Received on Wed Oct 31 2001 - 13:33:21 CST

Original text of this message

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