Hi,
query v$db_object_cache for colum namespace,sharable_mem and sum up the value got from sharable_mem.

regards
anandkl