Disclaimer

Thursday, 22 July 2021

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.

 

No comments:

Post a Comment

Understanding CSSD Heartbeat Mechanisms in Oracle RAC

  Understanding CSSD Heartbeat Mechanisms in Oracle RAC The Cluster Services Synchronization Daemon (CSSD) is a critical process in Oracle...