Query : Find Request Group name for Concurrent program name
Very useful query to retreive the Request Group and other information for Concurrent program from its name : SELECT cpt.user_concurrent_program_name "Concurrent Program Name", DECODE(rgu.request_unit_type, 'P', 'Program', 'S', 'Set', rgu.request_unit_type) "Unit Type", cp.concurrent_program_name "Concurrent Program Short Name", rg.application_id "Application ID", ...