Apps DBA

Query To find the details of the Accounting Flexfield structure … Read more

Query To Find a Scheduled Job for a particular program … 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 … Read more

How to Find the Request Group Associated with a Program. … Read more

Query To Find Global Locks Select Count(*)FROM gv$lock aWHERE a.id1 … Read more

Query To Check Web Sessions SELECT Count(*)FROM v$process p,gv$session sWHERE … 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 … Read more

Query To Find Complete Database Size SELECT ‘DATA_n_INDEX:’|| SUM(bytes)/1024/1024/1024|| ‘GBytes’ … Read more

Query To Find Application User Details SELECT user_name,user_id,Decode(employee_id, NULL, NULL,‘E’) … Read more

Query To Find EBS Profile Options For All Values SELECT … Read more