Re: Data base server Slow performance..(Urgent) (252 Views)
Reply
Frequent Advisor
Kannandgl_1
Posts: 91
Registered: ‎02-17-2008
Message 1 of 3 (290 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.

 

Please use plain text.
Valued Contributor
DeafFrog
Posts: 294
Registered: ‎02-25-2009
Message 2 of 3 (268 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
Please use plain text.
首席顾问
西北男人
Posts: 284
Registered: ‎03-14-2012
Message 3 of 3 (252 Views)

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

I just run into the same problems

Please use plain text.
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