Re: ioexception: end of tns data channel

From: curwen <josephcurwen_at_despammed.com>
Date: 24 Aug 2004 00:58:19 -0700
Message-ID: <cc68edc4.0408232358.2005be43@posting.google.com>

> The previous poster asked whether you are using multithreaded server,
> now known as shared server. In that case your mts_dispatcher init.ora
> parameter must be set to something meaningful and v$mts, and
> v$dispatcher will show whether you are actually using it.
> If you are using more or less stateless connections (ie your app
> continually connects and disconnects) using MTS is more or less
> mandatory, because when you don't disconnect gracefully, the dedicated
> server session on the database server will remain forever.

yes,
we are using it

v$parameters:

# NUM NAME                   TYPE VALUE                               
  ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISMODIFIED ISADJUSTED
DESCRIPTION                          UPDATE_COMMENT
= === ====================== ====
====================================== ========= ================
================ ========== ==========
==================================== ==============
1 505 mts_dispatchers        2   
(protocol=TCP)(listener=LISTENERS_krp) TRUE      FALSE           
IMMEDIATE        FALSE      FALSE      specifications of dispatchers  
     {null}
2 507 mts_servers            3    1                                   
  TRUE      FALSE            IMMEDIATE        FALSE      FALSE     
number of shared servers to start up {null}
3 509 mts_max_servers        3    20                                  
  TRUE      FALSE            FALSE            FALSE      FALSE     
max number of shared servers         {null}
4 511 mts_max_dispatchers    3    5                                   
  TRUE      FALSE            FALSE            FALSE      FALSE     
max number of dispatchers            {null}
5 513 mts_circuits           3    170                                 
  TRUE      FALSE            FALSE            FALSE      FALSE     
max number of circuits               {null}
6 515 mts_sessions           3    165                                 
  TRUE      FALSE            FALSE            FALSE      FALSE     
max number of shared server sessions {null}
7 521 mts_service            2    krp                                 
  TRUE      FALSE            FALSE            FALSE      FALSE     
service supported by dispatchers     {null}
8 522 mts_listener_address   2    {null}                              
  TRUE      FALSE            FALSE            FALSE      FALSE     
address(es) of network listener      {null}
9 523 mts_multiple_listeners 1    FALSE                               
  TRUE      FALSE            FALSE            FALSE      FALSE     
Are multiple listeners enabled?      {null}

v$mts:
# MAXIMUM_CONNECTIONS MAXIMUM_SESSIONS SERVERS_STARTED SERVERS_TERMINATED SERVERS_HIGHWATER

= =================== ================ ===============
================== =================
1 170                 90               347             347            

   5

v$dispatcher:

# NAME NETWORK                                            PADDR   
STATUS ACCEPT MESSAGES  BYTES       BREAKS OWNED CREATED IDLE      

BUSY LISTENER CONF_INDX

= ==== ================================================== ========
====== ====== ========= =========== ====== ===== ======= ==========

======= ======== =========
1 D000 (ADDRESS=(PROTOCOL=tcp)(HOST=dbnode1)(PORT=32783)) 59290B68

WAIT   YES    192620718 -1931975707 0      14    2768011 2620086507
1091422 0        0

the session number is very close to the max number of circuits , is it correct?

thanks for help
jc Received on Tue Aug 24 2004 - 02:58:19 CDT