Re: Found dead multi-threaded server

From: Philip Ross <philip_ross_at_my-deja.com>
Date: Wed, 3 Oct 2001 09:17:30 +0100
Message-ID: <uQzu7.19044$KJ4.3275127@news6-win.server.ntlworld.com>

"JimmyN1" <jimmyn1_at_aol.com> wrote in message news:20011002131622.28473.00000637_at_mb-fr.aol.com...
> let's take a look at other resources:
>
> select * from v$resource_limit;
>
> are there any resource constraints?

SQL> column resource_name format a21;
SQL> select * from v$resource_limit;

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU

--------------------- ------------------- --------------- ---------- -------
---
processes                              38              39        150
150
sessions                               91             104        170
170
enqueue_locks                          15              21       3054
3054
enqueue_resources                      15              39       1792
1792
_lm_procs                               0               0          0
0
lm_ress                                 0               0          0
UNLIMITED
lm_locks                                0               0          0
UNLIMITED
lm_cache_ress                           0               0          0
UNLIMITED
dml_locks                               0              22        748
748
temporary_table_locks                   0              12  UNLIMITED
UNLIMITED
transactions                            0               5        187

187

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU

--------------------- ------------------- --------------- ---------- -------
---
sort_segment_locks                      0              11  UNLIMITED
UNLIMITED
max_rollback_segments                  26              26         38
38
distributed_transacti                   0               0         10

10
ons

mts_max_servers                         3              15         20
20
parallel_max_servers                    0               0          6

6

16 rows selected.

SQL> spool off;

We have found a workaround for the problem now anyway. The Delphi BDE clients have now been changed to use Oracle dedicated servers by alterning the tnsnames.ora file. This has stopped the problem occuring.

Phil Received on Wed Oct 03 2001 - 03:17:30 CDT