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