Object documentationUSERSTATISTICS Locate this document in the navigation structure

 

The statistics system table <DATABASE_SYSTEM_ADMINISTRATOR>.USERSTATISTICS contains information about the resource consumption of database 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

More Information

Database Administration, Database Users