ITPub博客

首页 > Linux操作系统 > Linux操作系统 > V$SHARED_POOL_ADVICE

V$SHARED_POOL_ADVICE

原创 Linux操作系统 作者:bbs159 时间:2011-05-23 10:02:27 0 删除 编辑

V$SHARED_POOL_ADVICE

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

 

 

 

SHARED_POOL_SIZE_FOR_ESTIMATE  估计共享池大小

SHARED_POOL_SIZE_FACTOR    估计共享池大小与当前大小对比值

ESTD_LC_SIZE          估算共享池用于 library cache 的大小

ESTD_LC_MEMORY_OBJECTS          估算 library cache 对象数

ESTD_LC_TIME_SAVED       估计可以节省的时间,这个时间=载入共享池所需的消耗与从library cache读入所花费时间的差值

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13824386/viewspace-696019/,如需转载,请注明出处,否则将追究法律责任。

下一篇: V$LIBRARYCACHE
请登录后发表评论 登录
全部评论

注册时间:2011-05-11

  • 博文量
    26
  • 访问量
    41948