v$mystat, v$statname

v$mystat

 

by which we can select current session id and performance consume.

 

v$sessstat is for sessions sid of instance

 

v$sysstat is for all session of database.

 

v$statname:

 

Column	Datatype	Description
STATISTIC#	NUMBER	Statistic number Note: Statistics numbers are not guaranteed to remain constant from one release to another. Therefore, you should rely on the statistics name rather than its number in your applications.
NAME	VARCHAR2(64)	Statistic name
CLASS	NUMBER	A number representing one or more statistics classes. The following class numbers are additive: 1 - User 2 - Redo 4 - Enqueue 8 - Cache 16 - OS 32 - Real Application Clusters 64 - SQL 128 - Debug
STAT_ID	NUMBER	Identifier of the statistic

SELECT

t. * , s . *

FROM v$mystat t, v$statname s

WHERE s . statistic# = t. statistic# ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22936840/viewspace-749432/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22936840/viewspace-749432/