v$shared_pool_advice用于对shared_pool进行调优时做参考,他是分别对当前的shared pool值的10%-200%做假定的shared pool大小,根据这个假定的大小来观察各个参数的数值。。
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 |
1、
shared_pool_size_for_estimate 假定的shared_pool的大小,单位mb。
2、shared_pool_size_factor 假定的shared pool的大小与当前的shared pool真实大小的比值。
3、estd_lc_size 假设共享池的大小为shared_pool_size_for_estimate时,library cache所用的空间大小。
4、estd_lc_memory_object 假定的shared_pool大小下,library cache中对象的个数。
5、estd_lc_time_saved 在假定的shared pool大小下,节省的解析对象所用的时间值。
6、estd_lc_time_saved_factor 在假定的shared_pool大小下,节省的对象解析时间与当前真实shared_pool大小下节省的解析对象所花费时间的比值。
7、estd_lc_load_time 在假定的shared_pool大小下,解析对象所花费的时间。
8、estd_lc_load_time_factor 在假定的shared_pool大小下,解析对象花费的时间与当前真实shared_pool大小下解析对象花费时间的比值。
9、estd_lc_memory_object_hits 在假定的shared_pool大小下,共享池中对象命中的次数。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23655288/viewspace-718078/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23655288/viewspace-718078/