Query to see OS process id given to Concurrent Manager

Query to see OS process id given to Concurrent Manager

Query to see OS process id given to Concurrent Manager (Fndlibr):-

SELECT a.concurrent_queue_name, SUBSTR(b.os_process_id,0,10) "OS Proc", b.oracle_process_id "Oracle ID",  b.process_status_codeFROM fnd_concurrent_queues a, fnd_concurrent_processes b
WHERE a.concurrent_queue_id=b.concurrent_queue_id
AND b.process_status_code='A'
ORDER BY b.process_status_code;

 

 

 

Script to Check Invalid Objects in a Database

Select decode( object_type, 'PACKAGE BODY', 'ALTER PACKAGE ' || owner ||'.' || OBJECT_NAME || ' COMPILE BODY;','ALTER ' || owner ||'.'|| OBJECT_TYPE || ' ' || OBJECT_NAME || ' compile;' )
from dba_objects
where status = 'INVALID'
order by object_type;

 

 

 

Script to Recompile all user level Objects

set heading off
set feedback off
spool x.dat

select 'alter ' || decode(object_type,'PACKAGE BODY','PACKAGE',object_type) || ' ' || object_name || ' compile ' || decode(object_type,'PACKAGE BODY',' body;',';')
from user_objects
where object_type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE','TRIGGER','VIEW')
and status = 'INVALID'
order by object_type , object_name;

spool off
set heading on
set feedback on
@x.dat

Thanks

Srini