Oracle数据库各类指标统计的SQL语句.docVIP

Oracle数据库各类指标统计 目录 Access Report - List of objects in the database currently accessed by currently parsed cursors. Data Dictionary Cache Efficiency - Percentage of time that data dictionary data are found in the dictionary cache. Data Dictionary Details Report - Detail data about the data dictionary. Data Dictionary Report - Aggregate data about the data dictionary. DB Block Count - Count of gets in db block buffer. DB Block Efficiency - Percentage of time that requested data are found in the data cache. DB Block Report - Formatted SQL*Plus report with assorted buffer cache statistics. DB Block Usage - Lists status of all database blocks. Disk Reads Logical Max SQL - Returns the first 1000 bytes of the user SQL statement consuming the most blocks in the DB Block buffer. Disk Reads Logical Max User - Returns the username associated with the user SQL statement consuming the most blocks in the DB Block buffer. Disk Reads Physical Max SQL - Returns the first 1000 bytes of the user SQL statement having the highest number of physical disk read per statement execution. Disk Reads Physical Max SQL Current Session - Returns the first 1000 bytes of the user SQL statement having the highest number of physical disk reads per statement execution for current sessions. Disk Reads Physical Max User - Returns the username associated with the user SQL statement having the highest number of physical disk reads per statement execution. Extent List - Ordered list of table and index extent information. Extents Max Count - Largest number of extents used by any data base object, i.e. table or index. Extents Max Object Name - Name of the table or index using the maximum number of extents in any tablespace. File Report - Information about the Oracle data files. Free List Contention - Percentage of time that a request for data resulted in a wait for a free block. Index System Count - Number of indexes created in the SYSTEM tablespace by users. IO Network Bytes - Number of