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
;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 e
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
en
>
> 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
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
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 repea
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
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 g
> 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
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
m
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 wi
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=T
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 tak
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
> 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:
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
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
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
19 matches
Mail list logo
