topic Re: Caliper command line options in Operating System - HP-UX

Caliper command line options

placitasmd — Tue, 04 Nov 2008 02:57:54 GMT

What options should be selected when running caliper to get adequate inforamtion about a system that appears to be having cpu and/or I/O problems while doing a compress of an Oracle database?. A script that compresses 8 databases appears to be causing performance issues and we want to use caliper to try and determine what may be causing the problem

Re: Caliper command line options

Dennis Handly — Tue, 04 Nov 2008 04:46:58 GMT

Caliper may not be the right tool if you have system or I/O problems. You should first look at glance.

And if you are using oracle tools to compress the database, what are you going to do if you identify a problem?

Looking at the caliper web page:
http://www.hp.com/go/caliper
says you can ask for help here: caliper-help@cup.hp.com

Re: Caliper command line options

rick jones — Wed, 05 Nov 2008 00:02:10 GMT

Compress 8 databases how? That is with which utility and is it doing all 8 in parallel? This bare-iron or virtual machine?

Re: Caliper command line options

SUJOY SARASWATI — Wed, 05 Nov 2008 04:10:09 GMT

For I/O or disk bottleneck, Glance would be the right tool to use. If you are on HP-UX 11iV3, you can try the caliper cstack measurement on the suspect process. It will show the hot call stacks in the process; along with a status information of how much time the process was running and how much time it was blocked.

Re: Caliper command line options

placitasmd — Wed, 05 Nov 2008 14:35:49 GMT

The 8 databases are being compressed in parallel via a script that uses the standard unix compress command. This is on a VM guest. Guest and host are both running 11iV2 with IVM 3.5.

Re: Caliper command line options

rick jones — Wed, 05 Nov 2008 18:20:40 GMT

It isn't clear that Caliper is indicated here. I would probably go with a combination of glance and perhaps tusc for system call traces. If this is a vm guest the compute cycles of compression probably are not an issue (well, 8 in parallel probably presumes 8 virtual CPUS...) but I would be concerned about the number and size of the disc I/Os being performed. You would want to look at that in the guest and the host with glance, and at the app itself with tusc.

You may also want to consider examining utilities other than the standard compress. HP-UX also ships with gzip/gunzip and IIRC gunzip can uncompress that which was compressed by compress. The idea would be to find the utility which did the fewest I/Os to compress the file(s) to minimize the number of guest/host crossings.

Re: Caliper command line options

placitasmd — Thu, 13 Nov 2008 15:14:15 GMT