tutorailwale

Terminating Report From Backend, We should use data dictionary views v$session and v$process. SELECT oracle_process_id,Decode(status_code, ‘R’, ‘Running’,‘D’, ‘Canceled’,‘E’, ‘Error’,‘X’, ‘Terminated’,‘G’, ‘Warning’,‘T’, ‘Terminating’) ‘Status_code’,phase_code,To_char(actual_start_date, ‘DD-MON-YYYY=>hh24:mi:ss’) ‘Login … Read more

Query To Check Total Scheduled Requests SELECT request_id, id,Nvl(meaning, ‘UNKNOWN’),status,user_concurrent_program_name, pname,To_char(request_date, ‘DD-MON-RR HH24:MI:SS’), submitted,To_char(requested_start_date, ‘DD-MON-RR HH24:MI:SS’) requestedFROM fnd_concurrent_requests fcr,fnd_lookups fl,fnd_concurrent_programs_vl fcpvWHERE phase_code = ‘P’AND (fcr.requested_start_date … Read more

Query To Check List Of Running Requests SELECT q.concurrent_queue_nameqname,f.user_name,a.request_id“Req Id”,Decode(a.parent_request_id, –1, NULL,a.parent_request_id)“Parent”,a.concurrent_program_id“Prg Id”,a.phase_code,a.status_code— ,b.os_process_id “OS”— ,vs.sid— ,vs.serial# “Serial#”— ,vp.spid,a.oracle_process_id“spid”,( Nvl(a.actual_completion_date, SYSDATE) – a.actual_start_date ) * … Read more