Oracle Database 19c RAC New Dynamic Performance Views

Dynamic Performance Views

These are new 19c RAC dynamic performance views which are introduce in Oracle Database Release 19c.

GV$AQ_PARTITION_STATS 

GV$ASM_ACFSAUTORESIZE 

GV$ASM_DBCLONE_INFO 

GV$MEMOPTIMIZE_WRITE_AREA 

GV$SQL_TESTCASES

GV$AQ_PARTITION_STATS

displays usage statistics for the queue partition cache and the dequeue log partition cache.

GV$ASM_ACFSAUTORESIZE

displays the auto-resize settings for each mounted Oracle ACFS file system.

GV$ASM_DBCLONE_INFO

shows the relationship between the parent database and pointin-time database clones.

GV$MEMOPTIMIZE_WRITE_AREA

displays information about fast ingest data in the large pool.

GV$SQL_TESTCASES

displays information about test cases exported by SQL Test Case Builder.

With Best Wishes!!!!

Ahmad

Oracle Database Consultant

OCS (12c GG), OCE (11gR2 RAC)

OCP (11gR2/10gR2/9iR2), OCA (9i R2)

Oracle Ride!!

Reference-:http://www.oracle.com