Query to check the patches applied in current adop patch cycle R12.2

on

 Please find the query to find patches applied in current patch cycle of Oracle EBS R12.2.


col bug_number FOR a12
col applied_file_system_base FOR a35
set lines 999
col status FOR a8
col session_type FOR a12
col node_name FOR a12
SELECT adop_session_id,
       bug_number,
       session_type,
       Decode(status, 'N', 'Applied on other nodes',
                      'R', 'Running',
                      'H', 'Failed (Hard)',
                      'F', 'Failed (Jobs Skipped)',
                      'S', 'Success (Jobs Skipped)',
                      'Y', 'Success',
                      'C', 'Clone Complete')         status,
       applied_file_system_base,
       node_name,
       To_char(start_date, 'DD-MON-YY HH24:MI:SS')   start_time,
       To_char(end_date, 'DD-MON-YY HH24:MI:SS')     end_time,
       Round(( end_date - start_date ) * 24 * 60, 2) exec_time
FROM   apps.ad_adop_session_patches
WHERE  session_type IN ( 'ADPATCH', 'HOTPATCH', 'DOWNTIME', 'ONLINE' )
       AND patch_file_system_base IS NULL
ORDER  BY adop_session_id,
          start_date,
          end_date;
Sample output:


ADOP_SESSION_ID BUG_NUMBER   SESSION_TYPE STATUS   APPLIED_FILE_SYSTEM_BASE            NODE_NAME    START_TIME                  END_TIME                     EXEC_TIME
--------------- ------------ ------------ -------- ----------------------------------- ------------ --------------------------- --------------------------- ----------
             52 32394134     ONLINE       Success  /oracle/dbaarena/apps/fs2            dbarenamt101     22-JUN-22 02:40:12          22-JUN-22 03:43:09         62.95
             52 33441060     ONLINE       Success  /oracle/dbaarena/apps/fs2            dbarenamt101     22-JUN-22 02:40:12          22-JUN-22 03:43:09         62.95
             52 32392507     ONLINE       Running  /oracle/dbaarena/apps/fs2            dbarenamt101     22-JUN-22 03:47:39          22-JUN-22 03:55:29          7.83
             52 33550674     ONLINE       Running  /oracle/dbaarena/apps/fs2            dbarenamt101     22-JUN-22 03:47:39          22-JUN-22 03:55:29          7.83

Comments

Post a Comment