is there a way - Increasing the number of processes- Proirity

[gajananpkini]

hi

The number of processes has reached its limit of 400.

I want to increase it.

I know we can increase the number of process paramater to 700 in init.ora file, But i dont want to stop the Database server and restart it.

Is there a way DYNAMICALLY i can increase to 600 from 400.

please let me know

Thanks in advance

[hrishy]

Hi

I dont think so its possible in any version of oracle without bouncing the database.

SQL> select name,ISSYS_MODIFIABLE from v$parameter
2 where name like 'proc%';

NAME ISSYS_MOD
---------------------------------------------------------------- ---------
processes FALSE

i am on 9i.

regards
Hrishy

[gajananpkini]

SORRY i am using 8.1.7 under Linux

[hrishy]

Hi

On 8.1.7 or even 9i its not possible to alter it without bouncing back the database.

regards
Hrishy