topic Re: Performance issue in vclass in Operating System - HP-UX

Performance issue in vclass

kumaresan_1 — Mon, 17 Feb 2003 07:44:10 GMT

Hi All,

I am facing performance issue in my V2500 server its having 2cpu and 2gbram
With Hp-ux11.00 and oracle8i. More than 200 users using it. If users are Increasing
The performance was very slow and both the cpu Load is more than 10 and the Idle time is 0
I am here with attaching the top output and give the advices how to go about it.
Thanks in advance
Bye

Re: Performance issue in vclass

T G Manikandan — Mon, 17 Feb 2003 07:59:45 GMT

make sure that the kernel parameters are properly tuned.

What is your buffer cache value on the kernel?
i.e. dbc_max_pct.

If you have 2Gb RAM,make sure that your value does not exceed 300MB.
The default value is 50% ie.1GB in your case.

Also,are you running a MTS for the Oracle instance.
If you are running dedicated server mode then also each oracle client connection takes around 30MB in memory.
Looks like there are lot of processing going on in the machine.

check the usage of memory and swap using swapinfo -ta.

Also individual process memory usage can be calculated as

UNIX95= ps -e -o ruser,pid,vsz=Kbytes|more

Also,how is your I/O?Is it properly distributed?

You can use glance to find out the things in a easier way.

Thanks

Re: Performance issue in vclass

Ravi_8 — Mon, 17 Feb 2003 08:00:19 GMT

Hi,

could you reduce dbc_max_pct to 10 or 15, usuallyt it will be set to 50.