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

本站中文解释

Oracle视图v$shared_pool_advice是一个内置视图,它可以帮助用户建议修改内存池中的内存参数,从而改善共享池(内存池)的性能。

视图v$shared_pool_advice有以下字段:

NAME:显示注册应用程序所使用的内存池参数的名称。

V$SHARED_POOL_SIZE:显示内存池大小参数。

V$SHARED_POOL_RESERVED_SIZE:显示内存池可用空间参数。

V$SHARED_POOL_ALLOCATION_LIMIT:显示内存池总数参数。

V$SHARED_POOL_FLEX_SIZE:显示内存池的灵活性参数。

V$SHARED_POOL_ADVICE_HIT_RATIO:显示内存池命中率,这表明缓存的使用是否可以提高性能。

有了V$SHARED_POOL_ADVICE情况,DBA可以根据实际运行的情况,通过调整内存池的参数来改善内存池的性能。

官方英文解释

V$SHARED_POOL_ADVICE displays information about estimated parse time in the shared pool for different pool sizes. The sizes range from 10% of the current shared pool size or the amount of pinned library cache memory (whichever is higher) to 200% of the current shared pool size, in equal intervals. The value of the interval depends on the current size of the shared pool.
Column Datatype Description

SHARED_POOL_SIZE_FOR_ESTIMATE

NUMBER

Shared pool size for the estimate (in megabytes)

SHARED_POOL_SIZE_FACTOR

NUMBER

Size factor with respect to the current shared pool size

ESTD_LC_SIZE

NUMBER

Estimated memory in use by the library cache (in megabytes)

ESTD_LC_MEMORY_OBJECTS

NUMBER

Estimated number of library cache memory objects in the shared pool of the specified size

ESTD_LC_TIME_SAVED

NUMBER

Estimated elapsed parse time saved (in seconds), owing to library cache memory objects being found in a shared pool of the specified size. This is the time that would have been spent in reloading the required objects in the shared pool had they been aged out due to insufficient amount of available free memory.

ESTD_LC_TIME_SAVED_FACTOR

NUMBER

Estimated parse time saved factor with respect to the current shared pool size

ESTD_LC_LOAD_TIME

NUMBER

Estimated elapsed time (in seconds) for parsing in a shared pool of the specified size

ESTD_LC_LOAD_TIME_FACTOR

NUMBER

Estimated load time factor with respect to the current shared pool size

ESTD_LC_MEMORY_OBJECT_HITS

NUMBER

Estimated number of times a library cache memory object was found in a shared pool of the specified size

CON_ID

NUMBER

The ID of the container to which the data pertains. 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


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