topic Re: Data base server Slow performance..(Urgent) in Operating System - HP-UX

Data base server Slow performance..(Urgent)

Kannandgl_1 — Tue, 22 May 2012 18:41:33 GMT

Dear All,

I am using HP-UX 11.31.( 2 node cluster ) I am facing slow performance issue on my server. When I used check sar o/p it shows me CPU utilization always very high utilization.

First server : No of CPU: 8 , 32 GB RAM. Secondary Server : No of CPU 4 , 16 GB RAM. (errors)

Oracle DB vision 11gR2.

the filecache_Max value 99.9 % utilization and each and every oracle DB process its reserver for 2 GB I am worried about its any kernel parameters issue on my server. I am attaching the kernel my server kernel along with this post.

Regards

Rajamani.

Re: Data base server Slow performance..(Urgent)

DeafFrog — Wed, 23 May 2012 16:55:39 GMT

kcusage -S , ask dba topull out the statspack report , or check for disk contention sar -d 5 5 did you find and write wait , is the top processes using cpu is an oracle internal process or a sql query ?...check and post if problem still persists

Re: Data base server Slow performance..(Urgent)

西北男人 — Thu, 31 May 2012 15:56:27 GMT

I just run into the same problems