Disclaimer

Thursday, 22 July 2021

New initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c

 The following initialization parameters are new in Oracle Database Release 19c, Version 19.1:

  • ADG_REDIRECT_DML
  • DATA_GUARD_MAX_IO_TIME
  • DATA_GUARD_MAX_LONGIO_TIME
  • ENABLE_IMC_WITH_MIRA
  • LOB_SIGNATURE_ENABLE
  • MAX_DATAPUMP_PARALLEL_PER_JOB

The following static data dictionary views are new in Oracle Database Release 19c, Version 19.1:

  • ALL_TRIGGERS_AE, DBA_TRIGGERS_AE, and USER_TRIGGERS_AE
  • DBA_PDB_SNAPSHOTFILE
  • DBA_RAT_CAPTURE_SCHEMA_INFO
  • DBA_REGISTRY_BACKPORTS

The following dynamic performance views are new in Oracle Database Release 19c, Version 19.1:

  • GV$AQ_PARTITION_STATS and V$AQ_PARTITION_STATS
  • GV$ASM_ACFSAUTORESIZE and V$ASM_ACFSAUTORESIZE
  • GV$ASM_DBCLONE_INFO and V$ASM_DBCLONE_INFO
  • GV$SQL_TESTCASES and V$SQL_TESTCASES

No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...