V$SHARED_POOL_ADVICE

Data Dictionary View

Columns
   ___________________________
 
   SHARED_POOL_SIZE_FOR_ESTIMATE
   SHARED_POOL_SIZE_FACTOR
   ESTD_LC_SIZE
   ESTD_LC_MEMORY_OBJECTS
   ESTD_LC_TIME_SAVED
   ESTD_LC_TIME_SAVED_FACTOR
   ESTD_LC_MEMORY_OBJECT_HITS

Related: