session cached cursor statistics
From: Ojha, Ajeet (GE Healthcare, consultant) <"Ojha,>
Date: Wed, 7 Apr 2010 18:58:25 +0530
Message-ID: <A0B9A2F904FCDF43A5D1E286639257B6042A6DF5_at_BANMLVEM04.e2k.ad.ge.com>
Hi
Date: Wed, 7 Apr 2010 18:58:25 +0530
Message-ID: <A0B9A2F904FCDF43A5D1E286639257B6042A6DF5_at_BANMLVEM04.e2k.ad.ge.com>
Hi
I see the following in one of AWR reports :
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
Statistic
Begin Value
End Value
session cursor cache count
4,141,863
4,167,572
opened cursors current
633
549
workarea memory allocated
99,369
95,474
logons current
108
106
What should I understand from the above...what is the significance of Begin value and End values in the above table.
Where can I find the definitions of each of these statitics.
If someone can help me explain .
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 07 2010 - 08:28:25 CDT