| 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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
count, count, count, count, count, count, count, count, time.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
