What is the significance of this data dictionary column? [message #355110] |
Wed, 22 October 2008 13:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
efachim
Messages: 42 Registered: July 2008
|
Member |
|
|
Does anyone know the significance of the VALUE column on the v$sysstat dynamic performance table?
In the Oracle 11g Reference, they just describe it as a statistic value. Is it a time value, is it a count?
VALUE NUMBER Statistic value
Thanks, E.
|
|
|
|
Re: What is the significance of this data dictionary column? [message #355141 is a reply to message #355110] |
Wed, 22 October 2008 17:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
efachim
Messages: 42 Registered: July 2008
|
Member |
|
|
Hi Michel,
Here is a sample output from v$sysstat. Is the value referring to counts, time?
select statistic#, name, value from v$sysstat where rownum < 10;
statistic# name value
0 logons cumulative 462111
1 logons current 60
2 opened cursors cumulative 280890638
3 opened cursors current 331
4 user commits 968856
5 user rollbacks 171222
6 user calls 29308275
7 recursive calls 613920562
8 recursive cpu usage 5000686
|
|
|
Re: What is the significance of this data dictionary column? [message #355156 is a reply to message #355141] |
Wed, 22 October 2008 23:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
count, count, count, count, count, count, count, count, time.
Regards
Michel
|
|
|