How to check which security patches have been applied….

One can try this: set lin 700 col action_time format a30 col action format a20 col namespace format a20 col version format a10 col id format 999999999 col bundle_series format a15 col comments format a30 select * from dba_registry_history order by action_time;