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  

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-l
Received on Wed Apr 07 2010 - 08:28:25 CDT

Original text of this message