_____________________________________________________________________________________

RECOMPILE INVALID OBJECTS
=========================
@?/rdbms/admin/utlrp
_____________________________________________________________________________________

INVALID OBJECTS
===============
col owner for a20
col object_name for a50
select owner, object_name, object_type
from dba_objects where status = 'INVALID' order by 1, 2, 3;
_____________________________________________________________________________________

DEPENDENCIES
============
select d.owner, d.name, d.type, o.status, d.referenced_name, d.referenced_type
  from all_dependencies d, all_objects o
 where d.owner = o.owner
   and d.name  = o.object_name
   and d.type  = o.object_type
   and d.referenced_name  = 'EMP'
   and d.referenced_owner = 'SCOTT'
 order by 1, 2, 3;
_____________________________________________________________________________________

BLOCKED OBJECTS
===============
col object_name for a50
select l.session_id, l.oracle_username, o.owner, o.object_name 
from v$locked_object l, dba_objects o
where l.object_id = o.object_id and o.object_name = 'XXXNAMEXXX' order by 1;
_____________________________________________________________________________________

CREATION DATE
=============
select to_char(created,'YYYY-MM-DD_HH24:MI:SS') "CRE_DATE"
from dba_objects
where owner = 'SYS' and object_name = 'AWR_OUT_DIR';
_____________________________________________________________________________________

COMPILE MANUALLY
================
alter package scott.test_package compile;
alter package scott.test_package compile body;
_____________________________________________________________________________________