> 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: [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).
