Concurrent program executable file name

Select a.concurrent_program_id, c.user_concurrent_program_name, a.concurrent_program_name, b.executable_name, b.execution_file_name, b.execution_file_path,
DECODE(b.EXECUTION_METHOD_CODE,'Q','SQLPLUS','P','Oracle Reports','I','PL/SQL Stored Procedure','L','SQLLOADER','H','HOST','A','SPAWNED','J','JAVA','R','SQLREPORT','X','Flexrpt','S','IMMEDIATE', 'K', 'Java Concurrent Program', b.execution_method_code)
EXECUTION_METHOD_CODE
from fnd_concurrent_programs a,
     fnd_executables b,
     fnd_concurrent_programs_tl c
where a.executable_id = b.executable_id
and a.concurrent_program_id = c.concurrent_program_id
and c.user_concurrent_program_name like <concurr_prog_name>

Tablespace usage query

Tablespace usage in percentage

select  tsu.tablespace_name, ceil(tsu.used_mb) "size MB"
, decode(ceil(tsf.free_mb), NULL,0,ceil(tsf.free_mb)) "free MB"
, decode(100 - ceil(tsf.free_mb/tsu.used_mb*100), NULL, 100,
               100 - ceil(tsf.free_mb/tsu.used_mb*100)) "% used"
from (select tablespace_name, sum(bytes)/1024/1024 used_mb
 from  dba_data_files group by tablespace_name union all
 select  tablespace_name || '  **TEMP**'
 , sum(bytes)/1024/1024 used_mb
 from  dba_temp_files group by tablespace_name) tsu
, (select tablespace_name, sum(bytes)/1024/1024 free_mb
 from  dba_free_space group by tablespace_name) tsf
where tsu.tablespace_name = tsf.tablespace_name (+)
order by 4

Source: http://www.shutdownabort.com/dbaqueries/Structure_Tablespace.php

RequestSet+Stages+Programs+parameters (Oracle R12)

The query below lists Stages, programs and its parameters (only for particular type of program)

SELECT rs.request_set_id set_id,    --rsp.request_set_program_id,
  rs.user_request_set_name set_name,
  rstg.display_sequence seq, rstg.stage_name,
  rstgtl.user_stage_name,
  rsp.concurrent_program_id con_PROG_ID,
  CCP.user_concurrent_program_name,
  fccp.concurrent_program_name,
  (select Default_value from FND_REQUEST_SET_PROGRAM_ARGS x
  where x.request_set_id = rs.request_set_id
  and x.descriptive_flexfield_name = '$SRS$.XXOGL_F16_REPORT_FRAMEWORK'
  and x.application_column_name = 'ATTRIBUTE3' --the column used to store params
  and x.request_set_program_id = rsp.request_set_program_id
   ) "param: prog",
   (select Default_value from FND_REQUEST_SET_PROGRAM_ARGS x
  where x.request_set_id = rs.request_set_id
  and x.descriptive_flexfield_name = '$SRS$.XXOGL_F16_REPORT_FRAMEWORK'
  and x.application_column_name = 'ATTRIBUTE13'
  and x.request_set_program_id = rsp.request_set_program_id
   ) "param: parameter_list",
   (select Default_value from FND_REQUEST_SET_PROGRAM_ARGS x
  where x.request_set_id = rs.request_set_id
  and x.descriptive_flexfield_name = '$SRS$.XXOGL_F16_REPORT_FRAMEWORK'
  and x.application_column_name = 'ATTRIBUTE7'
  and x.request_set_program_id = rsp.request_set_program_id
   ) "param: destination"
FROM apps.fnd_request_Sets_tl rs,
  apps.FND_REQUEST_SET_STAGES RSTG,
  apps.fnd_REQUEST_SET_STAGES_tl rstgtl,
  apps.FND_REQUEST_SET_PROGRAMS RSP,
  apps.FND_CONCURRENT_PROGRAMS_TL CCP,
  apps.fnd_CONCURRENT_PROGRAMS fccp
WHERE RS.request_set_id = rstg.request_set_id
and rs.request_set_id = rstgtl.request_set_id
and rstg.request_set_id = rstgtl.request_set_id
and rstg.request_set_stage_id = rstgtl.request_set_stage_id
AND rs.request_set_id = rsp.request_set_id
AND rstg.request_set_stage_id = rsp.request_set_stage_id
AND rsp.concurrent_program_id = CCP.concurrent_program_id
and ccp.concurrent_program_id = fccp.concurrent_program_id
AND rs.user_request_set_name LIKE '<Request Set Name>' --'%F70 EOP%'
ORDER BY rstg.display_sequence