Apps DBA

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

Query To Find Number Of Users Connected To EBS SELECT … Read more

Query To Find Who is Connected When to Which Responsibilities … Read more

Query For Workflow Mailer Configurations SELECT p.parameter_id,p.parameter_name,v.parameter_value valueFROM apps.fnd_svc_comp_param_vals_v v,apps.fnd_svc_comp_params_b … Read more

Query To Find All Responsibilities Assigned To a User SELECT … Read more

Query To Get All Users Assigned To Given Responsibility SELECT … Read more