[dtrace-discuss] Oracle performance monitoring using Dtrace

[Foster, Gary]

Anyone done any oracle benchmarking using Dtrace?  I've been trying to delve
into figuring out why our oracle processes are consuming such utterly huge
amounts of system resources (other than the obvious "because it's Oracle..."
answer) and have been mired down in the ridiculously huge amount of probes
that exist in the oracle namespace.

Any help (RTFM's are welcome) or pointers on where to go to start whacking
at it with a machete would be gratefully appreciated.  I'd ideally like to
start out just determining and aggregatiung which internal Oracle functions
are being hit heaviest (cpu and wall time) but when I try to adapt the same
approach I use for monitoring heavy syscalls I get mired down due to the
roughly 30,000 probes that I'm somehow enabling :)

Anyone who has any ideas and can get me ontrack might find a couple bottles
of award-winning homebrew beer winging their way towards them in the post in
the near future!

-- Gary F.

Sent using the Microsoft Entourage 2004 for Mac Test Drive.