Originally posted by ptreves
Hello,

Let me get this right, this is what I need to do:

1) Set the PROCESSES parameter to a high value in the init.ora file located in $ORACLE_HOME/dbs folder (after shutting down my DB, of course).

2) Restart my DB

3) Run WebForms/WebReports

PT
That's right, try it to see if it works.

Originally posted by ptreves

Hello,

What I find funny about this particular problem, is that I have is that these errors occurs mostly when the WebReports are called from WebForms for the first time (using a arameter Form).

PT

PS: Any comments about that ?
You might run these two queries to see the actual status of processes and sessions when getting those errors.

--
-- Database processes Load
--

select pa.value as "Max Processes", count(*) as "Actual Processes",
pa.value - count(*) as "Process Free", round(count(*)*100/pa.value, 0) as "% Load"
from v$process p, (
select value
from v$parameter
where name = 'processes'
) pa
group by pa.value;

--
-- Database sessions Load
--

select pa.value as "Max Sessions", count(*) as "Actual Sessions",
pa.value - count(*) as "Sessions Free", round(count(*)*100/pa.value, 0) as "% Load"
from v$session p, (
select value
from v$parameter
where name = 'sessions'
) pa
group by pa.value;

Originally posted by davey23uk

not true, a session can have more that one process.

So my sessions could be low but still requiring processes to be high.

If you get max number of sessions exceeded you need to increase sessions not processes!
Thank you for adding that comment. I know that and tried to put things clearer.

Regards, Cesar Gamez