topic Re: Oracle processes in L2000 server in Operating System - HP-UX

Oracle processes in L2000 server

Shahul — Fri, 02 Nov 2001 05:47:03 GMT

Hi

I have an L2000 server with 1GB of RAM. Maximum howmany Oracle processes I can have in this? Right now I having 8i loaded in 11.0. If I am going for 9i what are all the requirements?

Thanks in advance
Shahul

Re: Oracle processes in L2000 server

Animesh Chakraborty — Fri, 02 Nov 2001 06:30:21 GMT

Hi,
oracle doc A90453-01 Installation Checklist states 9i requires a minimum of 256MB

Regards
Animesh

Re: Oracle processes in L2000 server

Alexander M. Ermes — Fri, 02 Nov 2001 06:50:16 GMT

Hi there.
Try to get the Oracle install and upgarde guide for HPUX. Read the install and the release note.
Rgds
Alexander M. Ermes

Re: Oracle processes in L2000 server

Animesh Chakraborty — Fri, 02 Nov 2001 08:45:58 GMT

hi,
Sorry fot the multiple entry...it was giving error so ....
Sahul here is good link for you.
http://technet.oracle.com/docs/products/oracle9i/pdf/9i_hp_install.pdf

Re: Oracle processes in L2000 server

Andreas D. Skjervold — Fri, 02 Nov 2001 10:01:36 GMT

Hi

The maximum number of user procesess against your system would be definded from the available memory, that is the total amount of memory minus the shared memory in use for the Oracle SGA and other processes using memory.

I belive each Oracle user process consumes aprox 20-25 Kbytes.

Andreas

Re: Oracle processes in L2000 server

Santosh Nair_1 — Fri, 02 Nov 2001 10:16:34 GMT

The maximum number of Oracle instances depends on the size of the database as defined by the SGA (which is locked into memory) and the number of clients connecting to the database (each spawns a process and thus eats up some memory).

But I would think you would be able to run at least 2 medium sized instances on this hardware.

-Santosh

Re: Oracle processes in L2000 server

Ravi_8 — Fri, 02 Nov 2001 10:25:18 GMT

Hi,
I am confused, do you want orcale processes or instances.Once you started a instance the respective processes will start. I am with 1 GB of RAM and 18GB HDD can run 3 instances simultaneously. More also can run,but it slowdown the system

Re: Oracle processes in L2000 server

Andreas D. Skjervold — Fri, 02 Nov 2001 10:40:25 GMT

Hi again

The number of instances possible is ofcourse dependend of the SGA size. I have a development server with 1 GB RAM and have up to 10 Oracle instances each having an SGA size of 50 MB. The 7 background procesess for each instance is neglible in size (7x20Kb).

If running Multithreaded server instead of dedicated server, most of the user process data is contained inside the SGA and are made common for all users ( they queue for the resources) and you can run a larger number of users than with dedicated. This might be preferable in enviroments where users perform select and updates at random times (ie office enviroment with many operators).
When running batch operations or continous processes against the database such as data loads and OLTP processing, dedicated server is preferable if not an requirement.

Andreas

Re: Oracle processes in L2000 server

Sanjay_6 — Fri, 02 Nov 2001 15:13:34 GMT

Hi shahul,

for oracle docs look at oracle doc site.

http://docs.oracle.com

Here is a link

http://docs.oracle.com/database_mp.html

Hope this helps.

Regds