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

Part Number B14237-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
Feedback

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