Oracle Database 19c RAC New Dynamic Performance Views

Published by Ahmad on

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


Leave a Reply

Your email address will not be published. Required fields are marked *