Any info on V$STATNAME?
From: <kaz_at_sis.bms.com>
Date: Thu, 14 Oct 1993 14:48:07 GMT
Message-ID: <1993Oct14.144807.5263_at_synapse.bms.com>
Joe Kazimierczyk
kaz_at_bms.com Received on Thu Oct 14 1993 - 15:48:07 CET
Date: Thu, 14 Oct 1993 14:48:07 GMT
Message-ID: <1993Oct14.144807.5263_at_synapse.bms.com>
Does anyone have or know where to find documentation on the V$STATNAME table?
I find it useful to join this with V$SESSSTAT like:
SELECT VALUE, A.STATISTIC#, NAME FROM V$SESSTAT A, V$STATNAME B WHERE SID = <some sid#> AND A.STATISTIC# = B.STATISTIC#;
Some of the resulting statistics are pretty obvious, but others are a bit of a mystery to me. If anyone has a short explanation of these, including what units are being used, I'd find it very helpful!
For example, for the following statistics, what do these mean? What are the units, especially for 'waits'?
STATISTIC# NAME
---------- ------------------- 32 db block changes 33 change write time 35 write complete waits 65 redo size
Thanks...
Joe Kazimierczyk
kaz_at_bms.com Received on Thu Oct 14 1993 - 15:48:07 CET