#To find concurrent programs for which trace is enabled
output_log=/tmp/practice/log.txt
export output_log
sqlplus -S
apps/apps << EOF
apps/apps << EOF
spool $output_log
set pages 1000
lines 1000
lines 1000
select
a.CONCURRENT_PROGRAM_ID, b.USER_CONCURRENT_PROGRAM_NAME
“Program_Name”, a.CONCURRENT_PROGRAM_NAME “Short_Name”,
a.APPLICATION_ID
a.CONCURRENT_PROGRAM_ID, b.USER_CONCURRENT_PROGRAM_NAME
“Program_Name”, a.CONCURRENT_PROGRAM_NAME “Short_Name”,
a.APPLICATION_ID
from
fnd_concurrent_programs a, fnd_concurrent_programs_tl b
fnd_concurrent_programs a, fnd_concurrent_programs_tl b
where
a.CONCURRENT_PROGRAM_ID=b.CONCURRENT_PROGRAM_ID and a.ENABLE_TRACE=’Y’;
a.CONCURRENT_PROGRAM_ID=b.CONCURRENT_PROGRAM_ID and a.ENABLE_TRACE=’Y’;
exit;
spool off
EOF
Recent Posts