Home » RDBMS Server » Performance Tuning » What is the significance of this data dictionary column? (Oracle 11g, 11.1.0, Linux)
What is the significance of this data dictionary column? [message #355110] Wed, 22 October 2008 13:05 Go to next message
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 #355118 is a reply to message #355110] Wed, 22 October 2008 14:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on the statistic.

Regards
Michel
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 messageGo to next message
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
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
count, count, count, count, count, count, count, count, time.

Regards
Michel
Previous Topic: Looking for a better access method
Next Topic: oracle volume
Goto Forum:
  


Current Time: Sat Dec 03 22:04:29 CST 2016

Total time taken to generate the page: 0.22639 seconds