Oracle教程 2023-03-22

Oracle 视图 DBA_HIST_TEMPSTATXS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_HIST_TEMPSTATXS用于存储每小时的系统和模式特殊统计信息，其中包含可用于衡量和优化性能的重要的聚合参数。

该视图中存储的数据是每个时段数据库的统计信息，捕获了每个时段的性能指标数据。它允许DBA对数据库每小时的统计信息进行查询，从而可以监控数据库在每个时段的性能和可用性，以及应用程序的工作量等级，并及时发现和解决性能问题。

使用该视图可以轻松快速的完成时段的性能分析，DBA可以使用该视图来定义数据库性能的指标，并使用相应的参数来分析不同时段数据库性能的变化情况。

官方英文解释

DBA_HIST_TEMPSTATXS displays information about temporary file read/write statistics.

This view contains snapshots of V$TEMPSTAT.

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`FILE#`	`NUMBER`	`NOT NULL`	File identification number
`CREATION_CHANGE#`	`NUMBER`	`NOT NULL`	Change number at which the temp file was created
`FILENAME`	`VARCHAR2(513)`	`NOT NULL`	Name of the temp file
`TS#`	`NUMBER`	`NOT NULL`	Tablespace number
`TSNAME`	`VARCHAR2(30)`		Name of the tablespace
`BLOCK_SIZE`	`NUMBER`		Block size of the temp file
`PHYRDS`	`NUMBER`		Number of physical reads done
`PHYWRTS`	`NUMBER`		Number of times DBWR is required to write
`SINGLEBLKRDS`	`NUMBER`		Number of single block reads
`READTIM`	`NUMBER`		Time (in hundredths of a second) spent doing reads if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`WRITETIM`	`NUMBER`		Time (in hundredths of a second) spent doing writes if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`SINGLEBLKRDTIM`	`NUMBER`		Cumulative single block read time (in hundredths of a second)
`PHYBLKRD`	`NUMBER`		Number of physical blocks read
`PHYBLKWRT`	`NUMBER`		Number of blocks written to disk, which may be the same as `PHYWRTS` if all writes are single blocks
`WAIT_COUNT`	`NUMBER`		Shows the number of waits at the file level for contended buffers. This value includes the individual wait events that are included in the buffer busy waits wait event. See Also: “buffer busy waits”
`TIME`	`NUMBER`		Time spent waiting for the wait events in the `WAIT_COUNT` column
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐