Query To Check List Of Locks In The Database SELECT a.inst_id,a.sid,a.TYPE,a.id1,a.id2,Decode(a.lmode, 0, ‘NONE’,1, ‘NULL’,2, ‘ROW SHARE’,3, ‘ROW EXCLUSIVE’,4, ‘SHARE’,5, ‘SHARE ROW EXCLUSIVE’,6, ‘EXCLUSIVE’,‘?’),Decode(a.request, 0, ‘NONE’,1, … Read more
Query To Check Blocking Sessions Per User SELECT s1.username|| ‘@’|| s1.machine|| ‘ ( SID=’|| s1.sid|| ‘ ) is blocking ‘|| s2.username|| ‘@’|| s2.machine|| ‘ ( … Read more
Query To Check Size Of All Tablespaces SELECT /* + RULE */ df.tablespace_name‘Tablespace’,df.bytes / ( 1024 * 1024 )‘Size (MB)”’,SUM(fs.bytes) / ( 1024 * 1024 … Read more
Query To find the details of the Accounting Flexfield structure SELECT gls.name,idfs.id_flex_num chart_of_accounts_id,idfs.segment_num,idfs.flex_value_set_id,fvs.flex_value_set_name,idfs.application_id,idfs.id_flex_code,idfs.application_column_name,idfs.segment_name,fvs.security_enabled_flag,( CASEWHEN fvs.validation_type = ‘F’ THEN ‘Table’WHEN fvs.validation_type = ‘I’ THEN ‘Independent’WHEN fvs.validation_type … Read more
Query To Find a Scheduled Job for a particular program SELECT a.requested_by,a.status_code,a.phase_code,a.request_id,b.user_concurrent_program_name,c.concurrent_program_name,a.requested_start_date,c.execution_method_code,d.execution_file_name,d.execution_file_pathFROM apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs_tl b,apps.fnd_concurrent_programs c,apps.fnd_executables dWHERE a.status_code IN ( ‘Q’, ‘I’ )AND a.concurrent_program_id = … Read more
How to Find Scheduled Concurrent Program SELECT a.requested_by,a.status_code,a.phase_code,a.request_id,b.user_concurrent_program_name,c.concurrent_program_name,a.requested_start_date,c.execution_method_code,d.execution_file_name,d.execution_file_pathFROM apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs_tl b,apps.fnd_concurrent_programs c,apps.fnd_executables dWHERE a.status_code IN ( ‘Q’, ‘I’ )AND a.concurrent_program_id = b.concurrent_program_idAND b.concurrent_program_id = c.concurrent_program_idAND … Read more
How to Find the Request Group Associated with a Program. SELECT rg.application_id“Request Group Application ID”,rg.request_group_id“Request Group – Group ID”,rg.request_group_name,rg.description,rgu.unit_application_id,rgu.request_group_id“Request Group Unit – Group ID”,rgu.request_unit_id,cp.concurrent_program_id,cp.concurrent_program_name,cpt.user_concurrent_program_name,Decode(rgu.request_unit_type, ‘P’, … Read more
Query To Find Global Locks Select Count(*)FROM gv$lock aWHERE a.id1 IN (SELECT id1FROM gv$lockWHERE request <> 0); Read More Articles Query To Check Web Sessions … Read more
Query To Check Web Sessions SELECT Count(*)FROM v$process p,gv$session sWHERE p.addr = s.paddrAND s.program = ‘JDBC Thin Client’; Read More Articles Query To Verify Workflow … Read more
Query To Verify Workflow IMAP Setting SELECT c.component_id,c.component_name,p.parameter_id,p.parameter_name,v.parameter_value valueFROM fnd_svc_comp_param_vals_v v,fnd_svc_comp_params_b p,fnd_svc_components cWHERE c.component_type = ‘WF_MAILER’AND v.component_id = c.component_idAND v.parameter_id = p.parameter_idAND p.parameter_name IN (‘INBOUND_SERVER’, … Read more