OS. Tru64 Unix ver 5.1
Oracle 8.1.7.2
m/c GS320 Alpha Server
After 900 User processes are Connected to a Database , sqlplus system/manager@
When issued DIRECTLY from the DB Server takes about 1 minute to Reach the SQL> prompt
Any parameters , pointers , Docs ?
--
Please see the official O
Probably configuration with shared server. Right?
Maybe after 900 users new server process is starting and this takes time,
but 1 minute looks too much.
Is this only the case when connecting from the server prompt or from
workstations as well?
Alexandre
> OS. Tru64 Unix ver 5.1
> Oracle 8.1.7.2
Hello VIVEK_SHARMA,
Do you use MTS?
Look at dispatchers load.
Tuesday, May 28, 2002, 3:33:18 PM, you wrote:
V> OS. Tru64 Unix ver 5.1
V> Oracle 8.1.7.2
V> m/c GS320 Alpha Server
V> After 900 User processes are Connected to a Database , sqlplus
system/manager@
V> When issued DIRECTLY from
NO MTS used
Dedicated Oracle Database Connect processes exist
Thanks
-Original Message-
Sent: Tuesday, May 28, 2002 2:53 PM
To: Multiple recipients of list ORACLE-L
Hello VIVEK_SHARMA,
Do you use MTS?
Look at dispatchers load.
Tuesday, May 28, 2002, 3:33:18 PM, you wrote:
V> OS.
it's possible this is (inadvertently) an Oracle Trace problem as Oracle
Trace is enabled by default from 7.3.2 on in Unix
Metalink note 45482.1 has information on how to disable it (see below).
I've seen this happen in just this way.
Workaround A - No Oracle Trace output required:
~~
what does uptime or top tell you when connections are
slow?
On Wed, May 29, 2002 at 02:23:30AM -0800, VIVEK_SHARMA wrote:
>
> NO MTS used
>
> Dedicated Oracle Database Connect processes exist
>
> Thanks
>
> -Original Message-
> Sent: Tuesday, May 28, 2002 2:53 PM
> To: Multiple reci
Hi,
--- When issued DIRECTLY from the DB Server takes about 1 minute to Reach the SQL>
prompt
That means you had narrowed down the problem. It's not realted to your network.
Debug your sqlplus command by truss,trace,strace etc. with its child process. If
problem occurs after
creating Oracle p