What is the significance of this data dictionary column? [message #355110] |
Wed, 22 October 2008 13:05 |
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 |
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 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
count, count, count, count, count, count, count, count, time.
Regards
Michel
|
|
|