Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 159 of 179


V$STATNAME

This view displays decoded statistic names for the statistics shown in the V$SESSTAT and V$SYSSTAT tables.

On some platforms, the NAME and CLASS columns contain additional operating system-specific statistics.

See Also:

 

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 

Statistic name 

CLASS  

NUMBER 

A number representing one or more statistics class. The following class numbers are additive:

  • 1, User

  • 2, Redo

  • 4, Enqueue

  • 8, Cache

  • 16, OS

  • 32, Parallel Server

  • 64, SQL

  • 128, Debug

 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index