Oracle 视图 V$JAVA_POOL_ADVICE 官方解释，作用，如何使用详细说明
本站中文解释
V$JAVA_POOL_ADVICE视图显示有关Java池的建议。 此外，您可以将其用于Java池内存设置的建议和池中内存的使用情况。
V$JAVA_POOL_ADVICE视图会定期跟踪JAVA POOL中的内存使用。它的列包括：
ADVICE：建议大小。
COUNTVALUE：计数值。
CURRENT_SIZE：当前大小，单位字节。
ELAPSED_TIME：与上次相比，从开始到现在经历的时间，单位秒。
SIZE_FACTOR：阈值。
SUGGESTED_SIZE：建议大小，单位字节。
用户可以使用这个V$JAVA_POOL_ADVICE视图来监控和调整JAVA POOL内存大小。使用下面的查询用于MONITORING:
select countvalue,suggested_size,current_size,size_factor,elapsed_time,advice
from v$java_pool_advice
order by countvalue;
可以使用PL/SQL编程来修改Java池大小，以便满足当前的内存使用量：
DECLARE
l_java_pool_size BINARY_INTEGER;
BEGIN
SELECT suggested_size
INTO l_java_pool_size
FROM v$java_pool_advice
WHERE advice=’YES’;
DBMS_JAVA.SET_POOL_SIZE(l_java_pool_size);
END;
/
官方英文解释
V$JAVA_POOL_ADVICE displays information about estimated parse time in the Java pool for different pool sizes.
The sizes range from 10% of the current Java pool size or the amount of pinned Java library cache memory (whichever is higher) to 200% of the current Java pool size, in equal intervals. The value of the interval depends on the current size of the Java pool.
Parse time saved refers to the amount of time saved by keeping library cache memory objects in the Java pool, as opposed to having to reload these objects.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Java pool size for the estimate (in megabytes) |
|
|
|
Size factor with respect to the current Java pool size |
|
|
|
Estimated memory in use by the library cache (in megabytes) |
|
|
|
Estimated number of library cache memory objects in the Java pool of the specified size |
|
|
|
Estimated elapsed parse time saved (in seconds), owing to library cache memory objects being found in a Java pool of the specified size. This is the time that would have been spent in reloading the required objects in the Java pool had they been aged out due to insufficient amount of available free memory. |
|
|
|
Estimated parse time saved factor with respect to the current Java pool size |
|
|
|
Estimated elapsed time (in seconds) for parsing in a Java pool of the specified size |
|
|
|
Estimated load time factor with respect to the current Java pool size |
|
|
|
Estimated number of times a library cache memory object was found in a Java pool of the specified size |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
