BladeSystem Forums have moved here
To make BladeSystem information easier to find, we have moved the BladeSystem forums here, to Servers and Operating Systems.
System Administration
Showing results for 
Search instead for 
Do you mean 

Data base server Slow performance..(Urgent)

Frequent Advisor

Data base server Slow performance..(Urgent)

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.

 

2 REPLIES
Valued Contributor

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

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

FrogIsDeaf
Highlighted
Super Advisor

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

I just run into the same problems