Oracle Tips : Solaris lgroups, CT optimization, Data Pump, Recompilation of Objects, ..

1. [Re]compiling all objects in a schema exec DBMS_UTILITY.compile_schema(schema => 'SCHEMA'); To recompile only the invalid objects in parallel: exec UTL_RECOMP.recomp_parallel(<NUM_PARALLEL_THREADS>, 'SCHEMA'); 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...

Read More