NUMBER Active server count → This column is available starting with Oracle Database 12 c Release 1 (12.1.0.2). Note: The ELAPSED_SCHEDULE_TIME column is only populated if the TIMED_STATISTICS initialization parameter is set to true, or if the STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL. See Also: \" TIMED_STATISTICS \" \" STATISTICS_LEVEL \"

New Features → $ENCRYPTION_KEYS GV$FLASHFILESTAT and V$FLASHFILESTAT GV$GG_APPLY_COORDINATOR and V$GG_APPLY_COORDINATOR … views are new in this release: GV$AQ_BACKGROUND_COORDINATOR and V$AQ_BACKGROUND_COORDINATOR GV … $AQ_BMAP_NONDUR_SUBSCRIBERS and V$AQ_BMAP_NONDUR_SUBSCRIBERS GV$AQ_CROSS_INSTANCE_JOBS

F Background Processes → , V$XSTREAM_APPLY_COORDINATOR for XStream, and V$GG_APPLY_COORDINATOR for Oracle GoldenGate. See … defined as any process that is listed in V$PROCESS and has a non- value in the PNAME column. The … . For more information about the coordinator process, see V$STREAMS_APPLY_COORDINATOR for Oracle Streams

Conditional Compilation Examples → Database release number. Each BOOLEAN constant of the form VER_LE_ v has the value TRUE if the database … version is less than or equal to v. otherwise, it has the value FALSE. Each BOOLEAN constant of the … form VER_LE_ v_r has the value TRUE if the database version is less than or equal to v and release

Cursors Overview → cursors that each user session currently has opened and parsed, query the dynamic performance view V … for information about the dynamic performance view V$OPEN_CURSOR Oracle Database Reference for information about the initialization parameter OPEN_CURSORS

Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO → You can use the V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO views to determine the source of backup or … restore bottlenecks and to see detailed progress of backup jobs. V$BACKUP_SYNC_IO contains rows when … the I/O is synchronous to the process (or thread on some platforms) performing the backup. V … SQL*Plus and

Using the V$DB_CACHE_ADVICE View → The V$DB_CACHE_ADVICE view shows the simulated miss rates for a range of potential buffer cache … is not used if the number of buffers in a buffer pool is small to begin with. To use the V … workload on the database instance. Allow the workload to stabilize before querying the V … $DB_CACHE_ADVICE view. Query the V$DB_CACHE_ADVICE