>
> What do you get when run this on the server hosting Oracle:
>
> lsnrctl services
>
>
Waleed, thanks for your input. Here is what I have (below are my MTS
settings)
MYDB has 1 service handler(s)
DEDICATED SERVER established:259 refused:1
LOCAL SERVER
MYDB has 6 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:2 refused:0 current:2 max:4000 state:ready
D004 <machine: MYSERVER, pid: 683>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2276))
DISPATCHER established:4 refused:0 current:0 max:4000 state:ready
D003 <machine: MYSERVER, pid: 636>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2275))
DISPATCHER established:1 refused:0 current:1 max:4000 state:ready
D002 <machine: MYSERVER, pid: 534>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2274))
DISPATCHER established:1 refused:0 current:1 max:4000 state:ready
D001 <machine: MYSERVER, pid: 301>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2273))
DISPATCHER established:1 refused:0 current:0 max:4000 state:ready
D000 <machine: MYSERVER, pid: 668>
(ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2272))
DB2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DB3 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
#######################################
MTS_DISPATCHERS="(protocol=tcp)(dispatchers=5)(pool=on)(tick=1)
(connections=1000)(sessions=4000)"
MTS_MAX_DISPATCHERS=32
MTS_SERVERS=5
MTS_MAX_SERVERS=64
MTS_SERVICE=MYDB
MTS_LISTENER_ADDRESS =
"(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MYSERVER))"
>
> Waleed, thanks for the reply here is what I have
>
> I have 26 sessions and 34 process, only one of which (my sqlplus
> session) that seems to indicate shared
> The rest seem to be remanents of the stored procedure.
>
> At the point of running this test, it was only myself
> monitoring and the developer repeadatly running his app which
> never ran the processses > 37 in about 15 min
>
> How else can I analyse this?
>
> Im wondering why only one session is in shared mode and the
> remainder are dedicated? And what mandates a shared
> connection over a dedicated?
>
> My sql+ which initiated the shared session was simply
> username/passwd_at_instance
>
> Thanks
> bob
>
> LOCALUSER_at_MYDB -> select count(*) from v$session;
>
> COUNT(*)
> ----------
> 26
>
> LOCALUSER_at_MYDB -> select count(*) from v$process;
>
> COUNT(*)
> ----------
> 37
>
> LOCALUSER_at_MYDB -> select
> decode(username,'SECUSER','LOCALUSER',NULL,'IS_NULL',
> username), status,
> program, server from v$session;
>
> DECODE(US STATUS PROGRAM
> SERVER
> --------- --------
> ----------------------------------------------------------------
> ---------
> IS_NULL ACTIVE ORACLE.EXE
> DEDICATED
> IS_NULL ACTIVE ORACLE.EXE
> DEDICATED
> IS_NULL ACTIVE ORACLE.EXE
> DEDICATED
> IS_NULL ACTIVE ORACLE.EXE
> DEDICATED
> IS_NULL ACTIVE ORACLE.EXE
> DEDICATED
> IS_NULL ACTIVE ORACLE.EXE
> DEDICATED
> username INACTIVE dbsnmp.exe
> DEDICATED
> LOCALUSER INACTIVE sqlplusw.exe
> NONE
> LOCALUSER INACTIVE sqlplusw.exe
> NONE
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> NONE
> LOCALUSER ACTIVE sqlplusw.exe
> SHARED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
> LOCALUSER INACTIVE
> DEDICATED
>
> 26 rows selected.
>
>
> > Do you know if the connections (sessions) created for the web
> > app are shared or dedicated? If it's dedicated, did you try
> > to connect using sqlplus from that win2k server and other hosts?
> >
> > Trying to isolate the problem?
> >
> > Regards,
> >
> > Waleed
> >
> >
> > -----Original Message-----
> > Sent: Thursday, December 26, 2002 10:44 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > > Does your app connect to the database using the listener
> or directly
> > > (BEQ) without specifying a connect string?
> > >
> > > It should connect using the listener and a connect string.
> > >
> > > Regards,
> > >
> > > Waleed
> > >
> >
> > Waleed
> >
> > Yes, it's a web application and uses a listener. The listener
> > entry has not been modified. There was a vague reference in
> > the MTS docs that eluded to using a special connection
> > string. But I got the impression that you would use a special
> > connection string *if* you wanted the abillity to chooose
> > between direct connection or mts (shared).
> >
> > In my case Id simply like to have all connections to use MTS.
> >
> > Should I be using a special connection string or listener
> > entry? If so where can I find some examples
> >
> > Here is my asp application connection string (using the
> > Oracle OLEDB provider wich is current)
> > Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persis
> > t Security Info=True;User ID=me;Data Source=mydb
> >
> > Here is my traditional sql+ connection
> > username/password_at_instance
> >
> > So, Im wondering what type of "special" connection string I'd
> > need for mts (if that's the case)
> >
> > Listener entry
> > (SID_DESC =
> > (GLOBAL_DBNAME =mydb)
> > (ORACLE_HOME = C:\Oracle\Ora81)
> > (SID_NAME = mydb)
> > )
> >
> > This is on win2k server, Oracle 8.1.7
> >
> > Thanks!
> > bob
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Bob Metelsky
> INET: bmetelsky_at_cps92.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: bmetelsky_at_cps92.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Dec 27 2002 - 07:49:04 CST
