USERSTATISTICS

Definition

The statistics system table USERSTATISTICS contains information about the resource consumption of users.

Structure

USERSTATISTICS

USERNAME

CHAR(32)

Name of the database user

USERMODE

CHAR(8)

Database user class

PERMCOUNT

FIXED(10)

Number of pages currently used for permanent objects

TEMPCOUNT

FIXED(10)

Number of pages currently used for temporary objects

See also:

Concepts of the Database System, Database Users