Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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

 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index