exec DBMS_UTILITY.compile_schema(schema => 'SCHEMA');To recompile only the invalid objects in parallel:
exec UTL_RECOMP.recomp_parallel(A NULL value for SCHEMA recompiles all invalid objects in the database.
2. SGA breakdown in Solaris Locality Groups (lgroup) To find the breakdown, execute
pmap -L | grep shm. Then separate the lines that are related to each locality group and sum up the value in 2nd column to arrive at a number that shows the total SGA memory allocated in that locality group.