You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for V$DATAGUARD_STATS


1 to 20 of 2549 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

V$DATAGUARD_STATS

7.142 V$DATAGUARD_STATSV$DATAGUARD_STATS displays information about Oracle Data Guard metrics when queried on a standby

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing a Logical Standby Database

11.3.3 V$DATAGUARD_STATS ViewFORMAT A30 SQL> SELECT NAME, VALUE, UNIT FROM V$DATAGUARD_STATS; NAME VALUE UNIT

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing a Logical Standby Database

11.3 Views Related to Managing and Monitoring a Logical Standby Databasedatabase: DBA_LOGSTDBY_EVENTS View DBA_LOGSTDBY_LOG View V$DATAGUARD_STATS View V$LOGSTDBY_PROCESS … View V$LOGSTDBY_PROGRESS View V$LOGSTDBY_STATE View V$LOGSTDBY_STATS View See Also: Oracle Database Reference for complete reference information about views

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents$DATAGUARD_STATS 7.143 V$DATAGUARD_STATUS 7.144 V$DB_CACHE_ADVICE 7.145 V$DB_OBJECT_CACHE 7.146 V … USER_ZONEMAP_MEASURES 6.624 USER_ZONEMAPS Part III Dynamic Performance Views 7 Dynamic Performance (V … $) Views: V$ACCESS to V$HVMASTER_INFO 7.1 About

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Role Transitions

9.1.2 Choosing a Target Standby Database for a Role Transition… Oracle Data Guard provides the V$DATAGUARD_STATS view, which you can use to evaluate each standby … , VALUE, DATUM_TIME FROM V$DATAGUARD_STATS; NAME VALUE DATUM_TIME

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Views Relevant to Oracle Data Guard

19 Views Relevant to Oracle Data Guardview before you perform a rolling upgrade using DBMS_ROLLING to determine what is unsupported. V … information in this view does not persist across an instance shutdown. V$ARCHIVE_DEST_STATUS Primary … log destinations. Note: The information in this view does not persist across an instance shutdown. V … archived redo log files.

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Database Management

Part V Distributed Database ManagementYou can manage a distributed database environment.

Database Concepts, 12c Release 1 (12.1)

Oracle Instance Architecture

Part V Oracle Instance ArchitectureThis part describes the basic structural architecture of the Oracle database instance. This part contains the following chapters: Oracle Database Instance Memory Architecture Process Architecture Application and Networking Architecture

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Managing Physical and Snapshot Standby Databases

10.2.2 DML Operations on Temporary Tables on Oracle Active Data Guard Instancesthe apply lag, query the V$DATAGUARD_STATS view. For example: SQL> SELECT name, value, datum_time … , time_computed FROM V$DATAGUARD_STATS - > WHERE name like 'apply lag'; NAME VALUE DATUM_TIME … started, query the V$STANDBY_EVENT_HISTOGRAM view. For example: SQL> SELECT * FROM V

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

PL/SQL Functions that SQL Statements Can InvokePackages and Types Reference. Dynamic performance views: [G]V$RESULT_CACHE_STATISTICS [G]V … $RESULT_CACHE_MEMORY [G]V$RESULT_CACHE_OBJECTS [G]V$RESULT_CACHE_DEPENDENCY See Oracle Database Reference for more … information about [G]V$RESULT_CACHE_STATISTICS, [G]V$RESULT_CACHE_MEMORY,

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

Declaring Associative Array Constants'; Ret(9):= 'nine'; RETURN Ret; END Init_My_AA; END My_Types; / DECLARE v CONSTANT My_Types.My_AA … DBMS_OUTPUT.PUT_LINE(TO_CHAR(Idx, '999')||LPAD(v(Idx), 7)); Idx:= v.NEXT(Idx); END LOOP; END; END

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics

Part V Optimizer StatisticsThe optimizer relies on statistics to create execution plans. This part contains the following chapters: Optimizer Statistics Concepts Histograms Managing Optimizer Statistics: Basic Topics Managing Optimizer Statistics: Advanced Topics

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Language Fundamentals

Conditional Compilation ExamplesDatabase 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Reserved Words and Keywords

D PL/SQL Reserved Words and Keywordscan display them with the dynamic performance view V$RESERVED_WORDS. For information about this view … , SQL, START, SUBTYPE T TABAUTH, TABLE, THEN, TO, TYPE U UNION, UNIQUE, UPDATE V VALUES, VIEW, VIEWS W … , UNSIGNED, UNTRUSTED, USE, USING V VALIST, VALUE, VARIABLE, VARIANCE, VARRAY, VARYING, VOID W WHILE, WORK, WRAPPED, WRITE Y YEAR

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

Formal and Actual Subprogram ParametersSUBTYPE n1 IS NUMBER(1); SUBTYPE v1 IS VARCHAR2(1); PROCEDURE p (n n1, v v1) IS... But you cannot … ), v VARCHAR2(1)) IS... Tip: To avoid confusion, use different names for formal and actual parameters

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Data Guard Concepts and Administration - Contents

Contents11.3.3 V$DATAGUARD_STATS View 11.3.4 V$LOGSTDBY_PROCESS View 11.3.5 V$LOGSTDBY_PROGRESS View 11.3.6 … Redo Data 7.2.2.1 Viewing Attributes With V$ARCHIVE_DEST 7.2.3 Configuring an Oracle Database to … Primary, Physical, and Snapshot Standby Databases 10.5.1.1 V$DATABASE 10.5.1.2 V$MANAGED_STANDBY

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

Cursors Overviewcursors 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

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Using DBMS_ROLLING to Perform a Rolling Upgrade

14.3 Planning a Rolling Upgradeatlanta START Start media recovery 69 atlanta START Wait until v$dataguard_stats has been initialized

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Tuning RMAN Performance

Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IOYou 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

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Database Buffer Cache

Using the V$DB_CACHE_ADVICE ViewThe 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