Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
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

CPU_COUNT

Maximum Number of CPUs

DATAFILES

Maximum Number of Datafiles

DB_SIZE

Maximum Size of the Database (Bytes)

INSTANCES

Oracle Database instances

PART_INDEXES

Maximum Number of Partitions belonging to an User Index

PART_TABLES

Maximum Number of Partitions belonging to an User Table

QUERY_LENGTH

Maximum Query Length

SEGMENT_SIZE

Size of Largest Segment (Bytes)

SESSIONS

Maximum Number of Concurrent Sessions seen in the database

SQL_NCHAR_COLUMNS

Maximum Number of SQL NCHAR Columns

TABLESPACES

Maximum Number of Tablespaces

USER_INDEXES

Number of User Indexes

USER_MV

Maximum Number of Materialized Views (User)

USER_TABLES

Number of User Tables