Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_HIGH_WATER_MARK_STATISTICS

DBA_HIGH_WATER_MARK_STATISTICS displays information about database high-watermark statistics.

Column Datatype NULL Description
DBID NUMBER NOT NULL Identifier of the database for which the high-watermark statistics are tracked
NAME VARCHAR2(64) NOT NULL Name of the high-watermark statistic (See Table 4-2)
VERSION VARCHAR2(17) NOT NULL Database version in which the high-watermarks were tracked
HIGHWATER NUMBER   Highest value of the statistic seen at sampling time
LAST_VALUE NUMBER   Value of the statistic at the last sample time
DESCRIPTION VARCHAR2(128)   Description of the high-watermark statistics (See Table 4-2)

Table 4-2 DBA_HIGH_WATER_MARK_STATISTICS Statistics

Name Description

USER_TABLES

Number of User Tables

SEGMENT_SIZE

Size of Largest Segment (Bytes)

PART_TABLES

Maximum Number of Partitions belonging to an User Table

PART_INDEXES

Maximum Number of Partitions belonging to an User Index

USER_INDEXES

Number of User Indexes

SESSIONS

Maximum Number of Concurrent Sessions seen in the database

DB_SIZE

Maximum Size of the Database (Bytes)

DATAFILES

Maximum Number of Datafiles

TABLESPACES

Maximum Number of Tablespaces

CPU_COUNT

Maximum Number of CPUs

QUERY_LENGTH

Maximum Query Length

SERVICES

Maximum Number of Services