how to increase processes?

[tracy]

hi,
how can i specifies the maximum number of operating system
user processes that can simultaneously connect to an Oracle
Server. Now, my processes is 350 and session is 390 and
parallel_max_se rver=5.

Pls let me know the command and i want to make it as permananet change
.. I am using oracle 9.2.0.2.0.

Thanz.

Regards,
Lee Cho

[sybrandb@yahoo.com]

Re: how to increase processes?

tracykim10@yaho o.com.hk (tracy) wrote in message news:<5c91cce9. 0408120007.54a3 d8dc@posting.go ogle.com>...

hi,
how can i specifies the maximum number of operating system
user processes that can simultaneously connect to an Oracle
Server. Now, my processes is 350 and session is 390 and
parallel_max_se rver=5.
>
Pls let me know the command and i want to make it as permananet change
. I am using oracle 9.2.0.2.0.
>
Thanz.
>
Regards,
Lee Cho

Just increase the processes parameter. Further details in the manual
you are too lazy to read.

Sybrand Bakker
Senior Oracle DBA

[Mark D Powell]

Re: how to increase processes?

tracykim10@yaho o.com.hk (tracy) wrote in message news:<5c91cce9. 0408120007.54a3 d8dc@posting.go ogle.com>...

hi,
how can i specifies the maximum number of operating system
user processes that can simultaneously connect to an Oracle
Server. Now, my processes is 350 and session is 390 and
parallel_max_se rver=5.
>
Pls let me know the command and i want to make it as permananet change
. I am using oracle 9.2.0.2.0.
>
Thanz.
>
Regards,
Lee Cho

Lee, pull the Oracle 9.2 Reference manaul and look up processes.

If you are running on UNIX you might also want to check on the ulimit
command which limits at the OS level how many processes, files, etc...
a user account may have.

By the way when a newsgroup has subgroups you should generally post to
the subgroups and not the newsgroup. Comp.database.o racle was split
several years ago into .server, .misc, .tools, and .marketplace.

HTH -- Mark D Powell --