Oracle Database 19c new Dynamic Performance Views

Dynamic Performance Views

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

V$AQ_PARTITION_STATS

V$ASM_ACFSAUTORESIZE

V$ASM_DBCLONE_INFO

V$MEMOPTIMIZE_WRITE_AREA

V$SQL_TESTCASES

V$AQ_PARTITION_STATS

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

V$ASM_ACFSAUTORESIZE

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

V$ASM_DBCLONE_INFO

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

V$MEMOPTIMIZE_WRITE_AREA

V$MEMOPTIMIZE_WRITE_AREA displays information about fast ingest data in the large pool.

V$SQL_TESTCASES

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

You can use this view in conjunction with the V$DIAG_INCIDENT view. Join the INCIDENT_ID column in this view with the INCIDENT_ID column in V$DIAG_INCIDENT to view information about the test case associated with a particular incident.

The V$SQL_TESTCASES view requires the existence of a TCB root directory named SQL_TCB_DIR. This view will not contain any rows if a TCB root directory does not exist,or if the TCB root directory exists with a name other than SQL_TCB_DIR.

The operating system directory to which the TCB root directory refers must be writable by the owner of the Oracle Database binaries.

In Oracle Autonomous Database environments, the TCB root directory is created automatically on each POD during provisioning.

For on-premises databases, a user who has been granted the DBA role must explicitly create the TCB root directory.

With Best Wishes!!!!

Ahmad

Oracle Database Consultant

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

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

Oracle Ride!!

Reference–: www.oracle.com