tool comparing statspacks

NetComrade

unread,

Mar 13, 2008, 4:00:17 PM3/13/08

to

Is there are a good tool that compares statspacks well?
something that would do a high level comparison, and display things
that changed more than X percentage points (10-20)

Thanks all!
.......
We run Oracle 9iR2,10gR1/2, 10gRAC on RH4/RH5 and Solaris 10 (Sparc)
remove NSPAM to email

gazzag

unread,

Mar 14, 2008, 12:15:09 PM3/14/08

to

awk? :)

-g

Frank van Bortel

unread,

Mar 14, 2008, 2:57:55 PM3/14/08

to

diff!

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

Eric Junkermann

unread,

Mar 16, 2008, 8:06:37 AM3/16/08

to

Since the statspack report is just a script reading the statspack
tables, why don't you look at the script, look at the tables, and roll
your own report.

E

Niall Litchfield

unread,

Mar 16, 2008, 5:48:54 PM3/16/08

to

On Mar 16, 12:06 pm, Eric Junkermann <e...@deptj.demon.co.uk> wrote:
>
> Since the statspack report is just a script reading the statspack
> tables, why don't you look at the script, look at the tables, and roll
> your own report.

Looking at the statspack script, and the associated package, and
entirely understanding it, is a little more complex than that raw
sentence suggests. Especially if you have to compare and contrast
different versions of statspack at maybe different levels.

Niall

NetComrade

unread,

Mar 17, 2008, 11:47:48 AM3/17/08

to

Thanks.. I've written some ugly SQL comparing some parts of
statspacks, but was curious if anyone wrote any tools.. I certainly
want to be re-inventing the wheel.

Eric Junkermann

unread,

Mar 17, 2008, 11:43:49 AM3/17/08

to

Depends where you are in the experience range I guess (and
how keen you are to do it). I've done it (for something adhoc)
(not cross-level), and moved on, thinking "I've done that, so I
can do it again". And I suppose I was building on a fair bit of
time spent understanding bstat/estat.

And I guess it was at least as helpful as giving 'awk' as a one-word
answer.

E

NetComrade

unread,

Mar 17, 2008, 8:24:10 PM3/17/08

to

On Mon, 17 Mar 2008 15:47:48 GMT, NetComrade
<netcomr...@bookexchange.net> wrote:

>On Sun, 16 Mar 2008 14:48:54 -0700 (PDT), Niall Litchfield
><niall.li...@gmail.com> wrote:
>
>>On Mar 16, 12:06 pm, Eric Junkermann <e...@deptj.demon.co.uk> wrote:
>>>
>>> Since the statspack report is just a script reading the statspack
>>> tables, why don't you look at the script, look at the tables, and roll
>>> your own report.
>>
>>Looking at the statspack script, and the associated package, and
>>entirely understanding it, is a little more complex than that raw
>>sentence suggests. Especially if you have to compare and contrast
>>different versions of statspack at maybe different levels.
>>
>>Niall
>
>Thanks.. I've written some ugly SQL comparing some parts of
>statspacks, but was curious if anyone wrote any tools.. I certainly
>want to be re-inventing the wheel.

That should've read '_don't_ want to be re-inventing the wheel'

.......
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
remove NSPAM to email