Data base server Slow performance..(Urgent) (327 Views)
Reply
Frequent Advisor
Kannandgl_1
Posts: 91
Registered: ‎02-17-2008
Message 1 of 3 (327 Views)

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.

 

Valued Contributor
DeafFrog
Posts: 294
Registered: ‎02-25-2009
Message 2 of 3 (305 Views)

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
首席顾问
西北男人
Posts: 291
Registered: ‎03-14-2012
Message 3 of 3 (289 Views)

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

I just run into the same problems

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.