> > 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@instance > > Thanks > bob > > LOCALUSER@MYDB -> select count(*) from v$session; > > COUNT(*) > ---------- > 26 > > LOCALUSER@MYDB -> select count(*) from v$process; > > COUNT(*) > ---------- > 37 > > LOCALUSER@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@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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).