REM Program: custom_18c.sql REM Oracle 18c PlugIn REM Version: 1.0.0 REM Author: Bartolomeo Bogliolo mail@meo.bogliolo.name REM https://www.md-c.it/meo/index.htm REM REM Date: 14-FEB-18 mail@meo.bogliolo.name REM First version with new useful queries available on 18 column con_name format a20 column con_id format a20 set lines 132 set define off set heading off select '

Oracle 18c 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 *
  FROM sys.dba_registry_sqlpatch
 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;