@utlrcmp.sql
exec utl_recomp.recomp_parallel(15);

select 'alter package ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'PACKAGE';
select 'alter package ' || owner || '.' || object_name || ' compile body;' from dba_objects where status = 'INVALID' and object_type = 'PACKAGE BODY';
select 'alter view ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'VIEW';
select 'alter procedure ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'PROCEDURE';
select 'alter trigger ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'TRIGGER';
select 'alter function ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'FUNCTION';
select 'alter java class ' || owner || '."' || object_name || '" compile;' from dba_objects where status = 'INVALID' and object_type = 'JAVA CLASS';
select 'alter type ' || owner || '.' || object_name || ' compile body;' from dba_objects where status = 'INVALID' and object_type = 'TYPE BODY';
select 'alter type ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'TYPE';
select 'alter materialized view ' || owner || '.' || object_name || ' compile;' from dba_objects where status = 'INVALID' and object_type = 'MATERIALIZED VIEW';

select object_name from dba_objects where owner = 'PORTAL30' and object_type = 'PACKAGE BODY'
minus
select object_name from dba_objects where owner = 'PORTAL30' and object_type = 'PACKAGE';

For a particular user:

select 'alter package ' || object_name || ' compile;' from user_objects where status = 'INVALID' and object_type = 'PACKAGE';
select 'alter package ' || object_name || ' compile body;' from user_objects where status = 'INVALID' and object_type = 'PACKAGE BODY';
select 'alter view ' || object_name || ' compile;' from user_objects where status = 'INVALID' and object_type = 'VIEW';
select 'alter procedure ' || object_name || ' compile;' from user_objects where status = 'INVALID' and object_type = 'PROCEDURE';
select 'alter trigger ' || object_name || ' compile;' from user_objects where status = 'INVALID' and object_type = 'TRIGGER';
select 'alter function ' || object_name || ' compile;' from user_objects where status = 'INVALID' and object_type = 'FUNCTION';
select 'alter java class "' || object_name || '" compile;' from user_objects where status = 'INVALID' and object_type = 'JAVA CLASS';





Just listing:

select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'PACKAGE';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'PACKAGE BODY';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'VIEW';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'PROCEDURE';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'TRIGGER';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'FUNCTION';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'JAVA CLASS';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'TYPE BODY';
select owner || '.' || object_name from dba_objects where status = 'INVALID' and object_type = 'TYPE';