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

本站中文解释

Oracle视图DBA_HIST_DB_CACHE_ADVICE定义了数据库每月缓存使用情况的历史记录,其中包括缓存命中比率、替换/清除信息以及其他提供的信息。可以用这个视图来发现一些改善数据库缓存使用的趋势,从而发现可以改进的地方。可以用这个视图确定系统表空间SGA中的缓存大小,以及如何改进缓存命中率以提高数据库性能。

官方英文解释

DBA_HIST_DB_CACHE_ADVICE displays historical predictions of the number of physical reads for the cache size corresponding to each row.

This view contains snapshots of V$DB_CACHE_ADVICE.

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

BPID

NUMBER

NOT NULL

Buffer Pool identifier (ranges from 1 to 8)

BUFFERS_FOR_ESTIMATE

NUMBER

NOT NULL

Cache size for prediction (in terms of buffers)

NAME

VARCHAR2(20)

Buffer pool name

BLOCK_SIZE

NUMBER

Block size in bytes for buffers in the pool (the standard block size, the power of 2 nonstandard block sizes, 2048, 4096, 8192, 16384, or 32768)

ADVICE_STATUS

VARCHAR2(3)

Status of the advisory:

  • ON – Currently running

  • OFF – Disabled (the estimates are historical and calculated when last enabled)

SIZE_FOR_ESTIMATE

NUMBER

Cache size for prediction (in megabytes)

SIZE_FACTOR

NUMBER

Size factor with respect to the current cache size

PHYSICAL_READS

NUMBER

Physical reads for the cache size

BASE_PHYSICAL_READS

NUMBER

Base physical reads for the cache size

ACTUAL_PHYSICAL_READS

NUMBER

Actual physical reads for the cache size

ESTD_PHYSICAL_READ_TIME

NUMBER

Estimated physical read time for the cache size

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

See Also:

“V$DB_CACHE_ADVICE”


数据运维技术 » Oracle 视图 DBA_HIST_DB_CACHE_ADVICE 官方解释,作用,如何使用详细说明