Oracle processes in L2000 server

[Shahul]

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

[Animesh Chakraborty]

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

Regards
Animesh

[Alexander M. Ermes]

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

[Animesh Chakraborty]

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

[Andreas D. Skjervold]

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

[Santosh Nair_1]

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

[Ravi_8]

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

[Andreas D. Skjervold]

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

[Sanjay_6]

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