Oracle, HP-UX 11 and use of memory

[Miguel Ustariz]

Exist some issues when we use HP-UX 11, Oracle 9.2 or 10g and the memory use ?. We have 5 GB of RAM, but Oracle installation in very slow and not finish, for example.

Thanks a lot...

[A. Clay Stephenson]

Have you checked to make sure that you have installed the patches listed in the Oracle Installation and Release notes? Have you set the kernel tunables to the recommended values? Have you reduced your max_dbc_pct from the default 50%?

[Miguel Ustariz]

the patchs are OK, Kernel parameters OK, but the last parameter is an Oracle o Unix parameter ?

[Hein van den Heuvel]

That last param is an hpux kernel setting.

But please describe better what is going on.

Is 'everything' slow, or specific phases?
When it is slow is there server activity like CPU or DISK?

Where is the kit? CD ? Net ? Local?
Try again after copying to local?


What GUI connection? env | grep DISPLAY ?
On several occasions I have has slow Oracle installs strictly due to poor network configs making my X-display back the workstation slow.
Does xclock or xeyes work correctly?

hth,
Hein.

[Julio Yamawaki]

Hi,

when installing Oracle 9.2/10g or any other that uses a java interface, memory is not the only request.
What model of HP box are you using?
I installed Oracle 9.2 in an old D280 and the first screen lasted about 7 minutes to appear...
In this machine, it took about 1.5 hour to finish oracle installation.
If you try to create database by using dbca in this case, probably you will have to wait for a long time.

[Miguel Ustariz]

OK It is a rp5470 box. That you right!. In installation phase of application server, forms and report; the installation hang a lot of time, but now apllitcation server is installed.

But with only 3 users and using the top command, you can see that the real memory can not pass over 2G and the virtual is up and up. We defined in SAM 5GB of memory !!

Can you see the attach

[A. Clay Stephenson]

Top is a meaningless tool for this. "Real" memory as reported by top is not physical memory. Top only knows about memory use related to processes; it knows nothing about kernel data structures like buffer cache.

[Julio Yamawaki · Accepted solution]

Hi,

That means you installed iAs, right?
In this case, memory will be consumed a lot.
Also, if you have problems of performance, this is because of java issues.
As an example, I have an installation of Oracle 10g + 10g iAs and it´s consuming 6 GB of memory - defined 12 GB of swap.
There some parameters to setup, like max_thread_proc, which is very important to java performance. In my case, I setup this parameter to 3000 to have a good performance.

[Miguel Ustariz]

You are right