check performance

[uadm26]

Hi,

The users are to complain that the system is very slow. The system support only a oracle databese server. How can i make un extensive analyzes of the performance of system, to know that's not system problem.

Thanks.

[MarkSyder]

If you have no tools like glance you can use those provided with hp-ux:

sar 2 5

will give you system activity report: 5 reports at 2 second intervals (adjust the numbers as required). Similarly

vmstat 2 5 and iostat 2 5

for virtual memory and input/output respectively.

Typing the word top and pressing enter will show you the processes taking up the most processor time.

Mark Syder (like the drink but spelt different)

[Simon Hargrave · Accepted solution]

You'll do a lot better if you have Glance/Measureware ( you can install a trial from the applications CD ), but basically you can try: -

top (this will show any processes hogging CPU time)
uptime (this will show run queue length, large numbers should be considered a busy server)
swapinfo -t (will show if disk swap space has been used)
vmstat 10 10 (will show if paging is actively happening, and therefore you don't have enough memory - look at the "po" column, you want little or no activity here ideally)
sar 10 10 (will show cpu usage over time, 100% utilisation generally will point to cpu bottleneck)
sar -d 10 10 (will show disk usage, and you should be able to determin if disk is your bottleneck).

So you basically need to see if your bottleneck is memory (not enough, so swapping), disk (too slow, to queuing), or cpu (rogue processes, or perhaps just asking too much of it), and go from there.

[uadm26]

Hi,

I'll create a script to put the information in some files, the work on it in my final report of the situation.
Any ideas to the script?

Thanks, Joel

[Geoff Wild]

I'm doing this with measureware from cron:

55 23 * * 1-5 /opt/perf/bin/extract -xp -r /home/gwild/zgbltemplate -g -b today 7:00 -e today 18:00 -f stdout | /bin/mailx -s 'svr002 performance report' gwild >/dev/null 2>&1


# cat /home/gwild/zgbltemplate
REPORT "MWA Export on !SYSTEM_ID"
FORMAT ASCII
HEADINGS ON
SEPARATOR="|"
SUMMARY=60
MISSING=0
DATA TYPE GLOBAL
YEAR
DATE
TIME
GBL_CPU_TOTAL_UTIL
GBL_MEM_UTIL
GBL_SWAP_SPACE_UTIL
GBL_MEM_CACHE_HIT_PCT
GBL_DISK_UTIL_PEAK
GBL_FS_SPACE_UTIL_PEAK


If just sar, then you can create reports like this:

0 7 * * * /usr/sbin/sar -d 600 72 > /tmp/sardaily.`"date"|awk '{print$2$3}'` 2>&1
55 5 * * * /usr/sbin/sar -u 2 750 > /tmp/sar555u.`"date"|awk '{print$2$3}'` 2>&1
55 5 * * * /usr/sbin/sar -d 2 750 > /tmp/sar555d.`"date"|awk '{print$2$3}'` 2>&1
55 9 * * * /usr/sbin/sar -u 2 750 > /tmp/sar955u.`"date"|awk '{print$2$3}'` 2>&1
55 9 * * * /usr/sbin/sar -d 2 750 > /tmp/sar955d.`"date"|awk '{print$2$3}'` 2>&1
55 16 * * * /usr/sbin/sar -u 2 750 > /tmp/sar1655u.`"date"|awk '{print$2$3}'` 2>&1
55 16 * * * /usr/sbin/sar -d 2 750 > /tmp/sar1655d.`"date"|awk '{print$2$3}'` 2>&1

Then mail them as well if you like...

Rgds...Geoff

[Mohanasundaram_1]

Hi,

If you are looking for some document on this then check this UPERFKBAN00000726 document on the knowledge base.

If you are unable to get it I can send you this document. it is around 19 pages.

Cheers,
mohan.

[uadm26]

Thanks, Mohanasundaram

Send to me the document to my email:
joel_azevedo@fidelidademundial.pt

Stay cool.

[Michael Tully]

Mohan,

You are not allowed to send these type of documents. You can of course paste a link, but that is all. They are for users that have support agreements only.

Regards
Michael

[Mohanasundaram_1]

Thanks Michael, for the alert at the right time.

I did not realise that point.

[Bill Hassell]

If you look at other psost here on the HP-UX forums about Oracle and performance, you'll find that there is not a lot you can change to improve Oracle without more RAM and a database administrator that can configure Oracle to take advantage of the additional memory. Similarly, the database admin should characterize the most intense SQL queries and rewrite them for more efficient operation such as adding additional indexes. There is no simple answer to fixing performance problems, especially without tools like Glance and Measureware. If you did not purchase these, you'll need to spend a lot of time learning about sar and vmstat and top, and read books like the HP-UX Performance book by Bob Sauers.

[Geoff Wild]

Just a fyi - here's a link the Performance Cookbook By Stephen Ciullo and Doug Grumann:

http://www.interex.org/pubcontent/enterprise/nov01/grumann.jsp

Rgds...Geoff

[Trond Haugen]

Without Glance and Measurware it's like fixing a flat bike tire without the right tools.
You should also ask the DBA to use the Oracle tools to look into performance.

Regards,
Trond