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 nnnnn".
>
> where nnnnn 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: 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).