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 |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7839206/viewspace-1031404/ ，如需转载，请注明出处，否则将追究法律责任。
