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