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

Index rebuild online in Oracle - shell script

  [oracle@rac10p reorg]$ cat index_rebuild_EMP.sh #!/bin/ksh export ORACLE_HOME=/oracle/K12/19 export ORACLE_SID=K12 export PATH=$PATH:/$ORA...