REM Program: custom_19c.sql REM Oracle 19c PlugIn REM Version: 1.0.0 REM Author: Bartolomeo Bogliolo mail@meo.bogliolo.name REM http://meoshome.it.eu.org/ REM REM Date: 14-FEB-18 mail@meo.bogliolo.name REM First version with new useful queries available on 19 column con_name format a20 column con_id format a20 column service_name format a20 set lines 132 set define off set heading off select '

Oracle 19c features

' h from dual; SELECT '

PDB Snapshots

' from dual;
set heading on
select CON_NAME, CON_ID, CON_UID, 
       SNAPSHOT_NAME, SNAPSHOT_TIME, SNAPSHOT_SCN,
       FULL_SNAPSHOT_PATH
  from DBA_PDB_SNAPSHOTS;
set heading off

REM  changed from 12... https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/DBA_REGISTRY_SQLPATCH.html
SELECT '

Patches

' from dual; 
set heading on
SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
	action,
	status,
	description,
	target_version,
	patch_id
  FROM sys.dba_registry_sqlpatch
 ORDER by action_time;
SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
       action,
       namespace,
       version,
       id,
       comments,
       bundle_series
  FROM sys.registry$history
 ORDER by action_time;
set heading off

SELECT '

Automatic In-Memory task

' from dual;
set heading on
select *
  from DBA_INMEMORY_AIMTASKDETAILS;
set heading off

SELECT '

Private temporary tables

' from dual;
set heading on
select *
  from DBA_PRIVATE_TEMP_TABLES;
set heading off

SELECT '

Connection tests

' from dual;
set heading on
select *
  from DBA_CONNECTION_TESTS;
set heading off

select '

Top Plugins

' from dual;