Find out application base path which is useful to find out the file on application server. SELECT fa.application_id "Application ID", fat.application_name "Application Name", fa.application_short_name "Application Short Name", fa.basepath "Basepath" FROM...

Observer CPU utilization of each query / session with details SELECT * FROM ( SELECT sql_text, cpu_time / 1000000 cpu_time, elapsed_time / 1000000 elapsed_time, disk_reads, buffer_gets, rows_processed FROM v$sqlarea ORDER...

User can find out the number of record in table SELECT table_name, TO_NUMBER(EXTRACTVALUE ( xmltype(DBMS_XMLGEN.getxml ( 'select count(*) c from ' || table_name)), '/ROWSET/ROW/C')) COUNT FROM user_tables WHERE table_name LIKE...

Sometimes concurrent request is running very slow or could not able to complete so user have to handle those request through follow few steps. Find out the request which is...

Details of concurrent request with user and period SELECT req.request_id, DECODE (prg.user_concurrent_program_name, 'Report Set', 'Report Set:' || req.description, prg.user_concurrent_program_name) AS name, argument_text AS parameters, req.resubmit_interval, NVL2 (req.resubmit_interval, 'Periodically', NVL2 (req.release_class_id,...

During the debug of form user face issue to find out the trace file of the activity. Below script make it easy to find trace file through concurrent request id....

Full details of blocking session SELECT s.inst_id, NVL (s.username, 'Internal') database_user, s.SID, s.event, s.p1, s.serial#, p.spid, m.TYPE, DECODE (m.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,...

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'...