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

SQL Queries for Goldengate Replications

  set linesize 200 set pagesize 100 set trimspool on column table_owner format a25 heading 'TABLE_OWNER' column tabl...