select
  shared_pool_size_for_estimate,           -- SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
  shared_pool_size_factor,                 -- SHARED_POOL_SIZE_FACTOR NUMBER
  estd_lc_size,                            -- ESTD_LC_SIZE NUMBER
  estd_lc_memory_objects,                  -- ESTD_LC_MEMORY_OBJECTS NUMBER
  estd_lc_time_saved,                      -- ESTD_LC_TIME_SAVED NUMBER
  estd_lc_time_saved_factor,               -- ESTD_LC_TIME_SAVED_FACTOR NUMBER
  estd_lc_load_time,                       -- ESTD_LC_LOAD_TIME NUMBER
  estd_lc_load_time_factor,                -- ESTD_LC_LOAD_TIME_FACTOR NUMBER
  estd_lc_memory_object_hits               -- ESTD_LC_MEMORY_OBJECT_HITS NUMBER
from
  gv$shared_pool_advice
where
  inst_id = USERENV('Instance')