RE: PMON seems to not close sessions in a timely manner eg Max
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
RE: PMON seems to not close sessions in a timely manner eg Max
Try: 1) Force shared connections using (SRVR=SHARED) in the tnsnames.ora. 2) Change the service name for the MTS_service and restart te db and listener. Make sure the service is registered with the listener. Add a new entry pointing to the new service in tnsnames.ora and let you app use this entry. I think the entry in tnsnames.ora will need to be like (service_name = ) instead of (sid = ). 3) sqlnet tracing may need to be done. Regards, Waleed -Original Message- Sent: Friday, December 27, 2002 8:49 AM To: Multiple recipients of list ORACLE-L 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)) -- 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).
RE: PMON seems to not close sessions in a timely manner eg Max
Title: Message Tehe, don't worry, Bob, the developers here work for me, so I can be as un-diplomatic as I wanna be. I don't know how you would do it in Micro$oft; perhaps some kind of component (.NET? DCOM?) could do this for them. I can do it in Java and Perl. Can't imagine that there isn't some mechanism out there for ASP/M$. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: PMON seems to not close sessions in a timely manner eg Max From: Bob Metelsky [mailto:[EMAIL PROTECTED]] I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached 1. 50 max processes? Damn, dude, you're choking that thing to death. 2. That is one of the sorriest excuses for a data access methodology that exists. Tell them to start pooling their database connections or you'll turn your max processes down even further. Hummm I have to be more diplomatic than that .. ;-) They are usingthe Oracle 8.17 provider with a connection string like so Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=a;Persist Security Info=True;User ID=a;Data Source=mydb Jeremy, do you have any examples of using pooled connections with active server pages? I'd like to be able to at least point them in the right direction and also have the information myself many thanks Bob
Re: PMON seems to not close sessions in a timely manner eg Max
And finally, although I hate asking the question: Why are you running MTS in the first place? I'm not saying there aren't good reasons for it - I'm just curious. Or to be "funny": I've solved many MTS-problems in my time by turning it off. However, that might not be possible or sensible in all cases. Mogens Khedr, Waleed wrote: Try: 1) Force shared connections using (SRVR=SHARED) in the tnsnames.ora. 2) Change the service name for the MTS_service and restart te db and listener. Make sure the service is registered with the listener. Add a new entry pointing to the new service in tnsnames.ora and let you app use this entry. I think the entry in tnsnames.ora will need to be like (service_name = ) instead of (sid = ). 3) sqlnet tracing may need to be done. Regards, Waleed -Original Message- Sent: Friday, December 27, 2002 8:49 AM To: Multiple recipients of list ORACLE-L 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))"
RE: PMON seems to not close sessions in a timely manner eg Max
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;Persist 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 -- 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).
RE: PMON seems to not close sessions in a timely manner eg Max
Title: Message From: Bob Metelsky [mailto:[EMAIL PROTECTED]] I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded "ORA-nnn max processes (50) reached" 1. 50 max processes? Damn, dude, you're choking that thing to death. 2. That is one of the sorriest excuses for a data access methodology that exists. Tell them to start pooling their database connections or you'll turn your max processes down even further. Hummm I have to be more diplomatic than that .. ;-) They are usingthe Oracle 8.17 provider with a connection string like so Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=a;Persist Security Info=True;User ID=a;Data Source=mydb Jeremy, do you have any examples of using pooled connections with active server pages? I'd like to be able to at least point them in the right direction and also have the information myself many thanks Bob
RE: PMON seems to not close sessions in a timely manner eg Max
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;Persist 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 -- 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).
RE: PMON seems to not close sessions in a timely manner eg Max
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).
RE: PMON seems to not close sessions in a timely manner eg Max
What do you get when run this on the server hosting Oracle: lsnrctl services Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/26/02 3:49 PM 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
Re: PMON seems to not close sessions in a timely manner eg Max
I think that you have to recheck the metalink doc that says that processes should not be more then v$license. lets say that your application opens 3 concurrent connections to the database. You buy 100 users license and can activate only 33 because your max processes is 100. Does not seem right to me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 24, 2002 5:33 PM select pid from v$process p,v$bgprocess b where b.paddr = p.addr and name = 'PMON' then oradebug wakeup n. where n is the process id Let me know if it works for you. Yes, I can do that but it seems like a manual process.I need something automatic.. No? Jared: We can bump up the processes but are worried about scaling. This was not an issue with one user, 2 users knocking the heck out of the app get processes = 50, so I would guess if users went to 100+ there could be an issue. Currently I have processes =100 and we don't get the error. Im looking for a setting that I can assign to have the processes clean up earlier. Ive read a article on Metalink saying processes should not be set to More than v$license More than 200 And is os dependant ? Thanks Bob -- 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: Yechiel Adar 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).
RE: PMON seems to not close sessions in a timely manner eg Max
You can try using the wakeup parameter of oradebug. You need to get the process ID of the pmon process, select pid from v$process p,v$bgprocess b where b.paddr = p.addr and name = 'PMON' then oradebug wakeup n. where n is the process id Let me know if it works for you. -Original Message- Sent: Tuesday, December 24, 2002 7:54 AM To: Multiple recipients of list ORACLE-L processes(50) reached I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached I can watch processes increse and decrese with v$session and v$process, they just dont seem to close quick enough. (however, they do eventually close) Any ideas what to look for. Ive searched Google and for parameters for PMON to no avail, hence I bring my delimma to the list I think I'd like to tell PMON how frequently to check for completed requests. thanks and happy holidays bob -- 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). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kurth, Michael J. 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).
Re: PMON seems to not close sessions in a timely manner eg Max processes(50) reached
Why not just increase max processes? Jared On Tuesday 24 December 2002 05:53, Bob Metelsky wrote: I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached I can watch processes increse and decrese with v$session and v$process, they just dont seem to close quick enough. (however, they do eventually close) Any ideas what to look for. Ive searched Google and for parameters for PMON to no avail, hence I bring my delimma to the list I think I'd like to tell PMON how frequently to check for completed requests. thanks and happy holidays bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
RE: PMON seems to not close sessions in a timely manner eg Max
select pid from v$process p,v$bgprocess b where b.paddr = p.addr and name = 'PMON' then oradebug wakeup n. where n is the process id Let me know if it works for you. Yes, I can do that but it seems like a manual process.I need something automatic.. No? Jared: We can bump up the processes but are worried about scaling. This was not an issue with one user, 2 users knocking the heck out of the app get processes = 50, so I would guess if users went to 100+ there could be an issue. Currently I have processes =100 and we don't get the error. Im looking for a setting that I can assign to have the processes clean up earlier. Ive read a article on Metalink saying processes should not be set to More than v$license More than 200 And is os dependant ? Thanks Bob -- 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).
RE: PMON seems to not close sessions in a timely manner eg Max
Add a dispatcher, configure MTS, min server processes and add an Oracle service for this MTS. An then let this app connect to Oracle through the MTS service. Regards, Waleed -Original Message- Sent: Tuesday, December 24, 2002 8:54 AM To: Multiple recipients of list ORACLE-L processes(50) reached I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached I can watch processes increse and decrese with v$session and v$process, they just dont seem to close quick enough. (however, they do eventually close) Any ideas what to look for. Ive searched Google and for parameters for PMON to no avail, hence I bring my delimma to the list I think I'd like to tell PMON how frequently to check for completed requests. thanks and happy holidays bob -- 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).
RE: PMON seems to not close sessions in a timely manner eg Max
Title: RE: PMON seems to not close sessions in a timely manner eg Max processes(50) reached From: Bob Metelsky [mailto:[EMAIL PROTECTED]] I have a developers stored procedure making repeaded calls (logons/request for data and logoff) Each call takes only seconds but it seems like PMON dosnt close the process in a timely manner, leaving what look to be ghost process. If a few users hit the same app the processes go to = 50 then I get the dreaded ORA-nnn max processes (50) reached 1. 50 max processes? Damn, dude, you're choking that thing to death. 2. That is one of the sorriest excuses for a data access methodology that exists. Tell them to start pooling their database connections or you'll turn your max processes down even further.
RE: PMON seems to not close sessions in a timely manner eg Max
Well, I had placed the db is MTS mode and still hit the max
processes(50)
#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))
And was able to have only shared connections as opposed to direct
connections
EG shows server=shared
select username, program, server from v$session
where audsid=userenv('sessionid');
I think Ive read all the docs I can find on multi threaded server but
did not see anything about creating a service or adding a dispatcher, Im
of the understanding that placing the above in my init.ora file, that
creates the dispatcher when I bounce the db? In this case as far as I
see my MTS service is MYDB.. Eg my SID
So, I must be missing something... I'd sincerely appreciate any
suggestions ... Examples?? From all the docs I see this is all that's
needed, obiviously not - Please advise
Thanks
bob
Add a dispatcher, configure MTS, min server processes and add
an Oracle service for this MTS.
An then let this app connect to Oracle through the MTS service.
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 24, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L
processes(50) reached
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like PMON dosnt
close the process in a timely manner, leaving what look to be
ghost process. If a few users hit the same app the processes
go to = 50 then I get the dreaded ORA-nnn max processes (50) reached
I can watch processes increse and decrese with v$session
and v$process, they just dont seem to close quick enough.
(however, they do eventually close)
Any ideas what to look for. Ive searched Google and for
parameters for PMON to no avail, hence I bring my delimma to the list
I think I'd like to tell PMON how frequently to check for
completed requests.
thanks and happy holidays
bob
--
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).
RE: PMON seems to not close sessions in a timely manner eg Max
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
-Original Message-
Sent: Tuesday, December 24, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Well, I had placed the db is MTS mode and still hit the max
processes(50)
#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))
And was able to have only shared connections as opposed to direct
connections
EG shows server=shared
select username, program, server from v$session
where audsid=userenv('sessionid');
I think Ive read all the docs I can find on multi threaded server but
did not see anything about creating a service or adding a dispatcher, Im
of the understanding that placing the above in my init.ora file, that
creates the dispatcher when I bounce the db? In this case as far as I
see my MTS service is MYDB.. Eg my SID
So, I must be missing something... I'd sincerely appreciate any
suggestions ... Examples?? From all the docs I see this is all that's
needed, obiviously not - Please advise
Thanks
bob
Add a dispatcher, configure MTS, min server processes and add
an Oracle service for this MTS.
An then let this app connect to Oracle through the MTS service.
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 24, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L
processes(50) reached
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like PMON dosnt
close the process in a timely manner, leaving what look to be
ghost process. If a few users hit the same app the processes
go to = 50 then I get the dreaded ORA-nnn max processes (50) reached
I can watch processes increse and decrese with v$session
and v$process, they just dont seem to close quick enough.
(however, they do eventually close)
Any ideas what to look for. Ive searched Google and for
parameters for PMON to no avail, hence I bring my delimma to the list
I think I'd like to tell PMON how frequently to check for
completed requests.
thanks and happy holidays
bob
--
--
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).
RE: PMON seems to not close sessions in a timely manner eg Max
Mine is 8.1.7.2 on HP.
In init.ora, processes=1000 sessions=1000 mts_servers=8, mts_max_servers=20,
dispatcher=10
I have not seen maximum process reached but have seen Deadlock: MTS Max
Servers (20) reached because applications had more than usual connections
once in a while. But that's ok with the applications.
Bing
-Original Message-
Sent: Tuesday, December 24, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
Well, I had placed the db is MTS mode and still hit the max
processes(50)
#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))
And was able to have only shared connections as opposed to direct
connections
EG shows server=shared
select username, program, server from v$session
where audsid=userenv('sessionid');
I think Ive read all the docs I can find on multi threaded server but
did not see anything about creating a service or adding a dispatcher, Im
of the understanding that placing the above in my init.ora file, that
creates the dispatcher when I bounce the db? In this case as far as I
see my MTS service is MYDB.. Eg my SID
So, I must be missing something... I'd sincerely appreciate any
suggestions ... Examples?? From all the docs I see this is all that's
needed, obiviously not - Please advise
Thanks
bob
Add a dispatcher, configure MTS, min server processes and add
an Oracle service for this MTS.
An then let this app connect to Oracle through the MTS service.
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 24, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L
processes(50) reached
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like PMON dosnt
close the process in a timely manner, leaving what look to be
ghost process. If a few users hit the same app the processes
go to = 50 then I get the dreaded ORA-nnn max processes (50) reached
I can watch processes increse and decrese with v$session
and v$process, they just dont seem to close quick enough.
(however, they do eventually close)
Any ideas what to look for. Ive searched Google and for
parameters for PMON to no avail, hence I bring my delimma to the list
I think I'd like to tell PMON how frequently to check for
completed requests.
thanks and happy holidays
bob
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wong, Bing
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
