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...
/ Posted by KapilUser 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...
/ Posted by KapilSometimes 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...
/ Posted by KapilDetails 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,...
/ Posted by KapilDuring 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....
/ Posted by KapilFull 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,...
/ Posted by KapilEasily 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'...
/ Posted by KapilGet 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,...
/ Posted by Kapil