Easily identify executable file name of concurrent request. SELECT fcpv.user_concurrent_program_name concurrent_program_name, fe.execution_file_name source_name, fl.meaning program_type FROM apps.fnd_concurrent_programs_vl fcpv, apps.fnd_executables fe, apps.fnd_lookups fl WHERE fe.executable_id = fcpv.executable_id AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'...

Get log file & output file location of concurrent request with all the details. SELECT DISTINCT fcp.user_concurrent_program_name, fcp.concurrent_program_name, fcr.request_id, fcr.request_date, flv.meaning status, fcr.status_code, fcr.completion_text, fcr.logfile_name, fcr.outfile_name, fcr.argument_text FROM apps.fnd_concurrent_programs_vl fcp,...

Discover concurrent request run in which concurrent manager SELECT a.include_flag, a.queue_application_id, c.user_concurrent_queue_name, d.user_concurrent_program_name FROM applsys.fnd_concurrent_queue_content a, applsys.fnd_concurrent_programs b, apps.fnd_concurrent_queues_vl c, fnd_concurrent_programs_tl d WHERE type_id = b.concurrent_program_id AND c.concurrent_queue_id = a.concurrent_queue_id...

Once applied the patch DBA can examine if any table is modified with the column name. SELECT table_name, column_name FROM dba_tab_columns WHERE table_name IN ('AP_INVOICES_INTERFACE', 'AP_INVOICE_LINES_INTERFACE', 'AP_INVOICES_ALL', 'AP_INVOICE_DISTRIBUTIONS_ALL', 'AP_INVOICE_LINES_ALL', 'AP_INVOICE_PAYMENTS_ALL',...

Find out value of profile option at any level from backend.  User have to enter the name of profile during the execution of script. SELECT b.user_profile_option_name "Long Name", a.profile_option_name "Short...

DBA can investigation which objects are invalid and they can take necessary action for those object. Number of objects are invalid by object types SELECT object_type, COUNT ( * )...

Check file version in application through sql script & linux/sun os command. Enter file name in below script which provide file version with location. SELECT af.app_short_name "Application", af.filename "File Name",...

Calculate total size of database and if you don't need size with TEMPFILE then you can make comment / remove the last line of script. SELECT SUM (bytes) / 1024...