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.
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:
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