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_server=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

Jul 19 '05 #1

Subscribe Post Reply

12750

sybrandb

tr********@yahoo.com.hk (tracy) wrote in message news:<5c**************************@posting.google. 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_server=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

Jul 19 '05 #2

Mark D Powell

tr********@yahoo.com.hk (tracy) wrote in message news:<5c**************************@posting.google. 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_server=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.oracle was split
several years ago into .server, .misc, .tools, and .marketplace.

HTH -- Mark D Powell --

Jul 19 '05 #3

by: Olaf Gschweng | last post by:

We're new into DB2 and have some problem with DB2 8.1 (?) on a Linux system. We load some big tables of a DB2 database from files every day. We do a "DELETE FROM table" for each table and then we...

DB2 Database

a processes cpu usage

by: Dirk Reske | last post by:

Hello, why doesn't this code work correctly? private int GetCpuUsage(Process proc) { DateTime time1,time2; TimeSpan timediff; double cpu1,cpu2,cpudiff;

C# / C Sharp

Multiple worker processes for a single application in a applicationpool

by: Abhishek Srivastava | last post by:

Hello All, In IIS 6.0 We have a concept of worker processes and application pools. As I understand it, we can have multiple worker process per appliction pool. Each worker process is dedicated...

ASP.NET

Threads vs Processes

by: Carl J. Van Arsdall | last post by:

Alright, based a on discussion on this mailing list, I've started to wonder, why use threads vs processes. So, If I have a system that has a large area of shared memory, which would be better? ...

Python

Increase default webservice timeout globally

by: =?Utf-8?B?c2FtZWVy?= | last post by:

environment : .net framework 1.1, ado.net, visual studio 2003, vb, sqlsever 2000, winforms, webforms I want to increase the timout of the webservice in the application which is being used in a...

.NET Framework

Monitor the increase of file size

by: =?Utf-8?B?ZGg=?= | last post by:

Two processes query a disk file's file size, concurrently and frequently (in a loop), using the following lines: FileInfo objFileSize = new FileInfo(fileToCheck); outputFileSize =...

C# / C Sharp

is there some per-process-limit on memory in .net processes? is there any way to increase it? i keep getting System.OutOfMemoryException when my box has 8 gigs of unused memory.

by: Daniel | last post by:

is there some per-process-limit on memory in .net processes? is there any way to increase it? i keep getting System.OutOfMemoryException when my box has 8 gigs of unused memory.

C# / C Sharp

C++ to Create and Manage Unix Processes

by: jazon | last post by:

Let me start by saying this for an Operating Systems class. No, I don't expect the work to be done for me. The assignment is as follows: To be honest, I feel like a fish out of water, like...