Hi,
I have collected the perfpmr data of server during slowdown behaviour and send to IBM for analysis.finally they have give me solution to go for more memory.They have traced out the process demands 5.81 GB of memory at the time of slowdown.
Thanx for all the helpful tips and suggestions...
Hi,
Thanx for all the replies.i have forwarded ur database related tips to my DBA and he is taking help from oracle support to tune oracle database parameters.
We have noticed a database process consuming around 25-30 % of cpu and when we checked for that particular process using "oradebug...
Hi,
The entire database is on hdisk5 (array of 7 disks-raid-5).The database is accessed by around 200 users.Rootvg is on hdisk0 and hdisk1(mirrored,but paging space is not mirrored).No data files or anything related with database is on rootvg.hdisk 0 and hdisk1 only contains rootvg.Other disks...
Hi Bi,
I have passed on ur suggestions to Oracle DBA.The problem is still not resloved even after changing database buffer size only the timings of problem are changed the problem usually comes in evening hours now.The Server goes slow down for a period of 40 minutes.I have shutdown the two...
Hi bi,
The DBA has reduced database buffer size yesterday and i have not faced the slowdown problem today morning.the entire database files are on external disk array(FAStT 500)which is on RAID-5.The DBA is unable to trace out any oracle process responsible for slowdown behaviour.I am unable to...
Thanks for the reply. I've been watching this server (with topas) all morning and now
I see that the rootvg disks (two local mirored disks) are running at 100% .This problem usually happens in morning between 10:00 a.m. to 12:00 p.m.Server stops responding for a period of around 30-40...
Hi,
Thanx for reply.How can i trace out the process consuming maximum amount of memory.The server is p-series 6H1 Server with 4-way processor(600 Mhz each)+ 4 GB Ram.How can i trace a particular oracle process or any other process consuming maximum amount of memory because on oracle all the...
Hi ,
sorry i have posted onw wrong value in vmtune parameters.here is the corect vmtune parametes that i have changed around one month back.
#vmtune parameters
/usr/samples/kernel/vmtune -p 5 -P 10 -t 10 -s 1 -R 8 -f 480 -F 512
/usr/samples/kernel/vmtune -b 200 -B 800
in vmstat output page...
Hi,
I am facing performance problem with one of our servers.I observed the server goes slow down the moment lrud process gets initiated. lrud process cpu usage in topas output is around 25% and hdisk 0 and hdisk 1(internal disks) gets 100 % utilized. None of the user will be able to connect to...
Hi Alexhu,
System is CPU Bound if in sar -u 60 30 output %usr+%sys > 80%.but ur sar output seems to be quite normal.Problem with ur vmstat output.In ur vmstat output paging space I/O is taking place approaching the systems memory limit.wa value of vmstat indicates I/O wait percentage of CPU AND...
Hi,
Try to trace out the process consuming maximum amount of memory.
ps aux | more
svmon -Pt 5
Post the output of following commands.
sar -u 5 10
vmstat 5 7
go to directory-/usr/samples/kernel
and run ./vmtune
post the outputs.
Regards
arvibm
Hi mjldba,
Try changing the parameters mentioned below,this will help u in improving the performance.
Performance improvement for FASTt
-------------------------------------
This info is generally applicable to AIX systems
using FAStT storage.
Config/tuning parameters for AIX using FAStT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.