How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
8.55 V$LOGSTDBY_PROGRESS → V$LOGSTDBY_PROGRESS displays the progress of log apply services on the logical standby database
11.3.5 V$LOGSTDBY_PROGRESS View → APPLIED_SCN, LATEST_SCN, MINING_SCN, RESTART_SCN - > FROM V$LOGSTDBY_PROGRESS; APPLIED_SCN LATEST_SCN … > SELECT APPLIED_TIME, LATEST_TIME, MINING_TIME, RESTART_TIME - > FROM V$LOGSTDBY_PROGRESS
5.147 DBA_LOGSTDBY_PROGRESS → in the V$LOGSTDBY_PROGRESS view. See Also: \" V$LOGSTDBY_PROGRESS \"
11.3 Views Related to Managing and Monitoring a Logical Standby Database → 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: DBA_LOGSTDBY_EVENTS View DBA_LOGSTDBY_LOG View V$DATAGUARD_STATS View V$LOGSTDBY_PROCESS
Contents → $LOGMNR_SESSION 8.52 V$LOGMNR_STATS 8.53 V$LOGSTDBY 8.54 V$LOGSTDBY_PROCESS 8.55 V$LOGSTDBY_PROGRESS … 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
15.2.3 Flashing Back a Logical Standby Database to a Specific Applied SCN → Apply has applied less than or up to the APPLIED_SCN. SQL> SELECT APPLIED_SCN FROM V$LOGSTDBY_PROGRESS;
11.4.1 Monitoring SQL Apply Progress → the V$LOGSTDBY_PROGRESS view: SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SQL … > SELECT APPLIED_TIME, APPLIED_SCN, MINING_TIME, MINING_SCN - > FROM V$LOGSTDBY_PROGRESS; APPLIED_TIME … . To determine the current state of SQL Apply, query the V$LOGSTDBY_STATE view. For example:
19 Views Relevant to Oracle Data Guard → standby database, and it can be helpful for other problems. V$LOGSTDBY_PROGRESS Logical only Displays the … view 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
13.5 Performing a Rolling Upgrade With an Existing Logical Standby Database → Database A, query the V$LOGSTDBY_PROGRESS view on Database B. For example: SQL> ALTER SESSION SET … NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI:SS'; Session altered. SQL> SELECT SYSDATE, APPLIED_TIME FROM V … $LOGSTDBY_PROGRESS; SYSDATE APPLIED_TIME ------------------ ------------------ 27-JUN-05 17:07:06 27-JUN-05
11.5.5 Adding or Re-Creating Tables On a Logical Standby Database → : SQL> SELECT APPLIED_SCN FROM V$LOGSTDBY_PROGRESS; APPLIED_SCN -------------------------- 345161345 … following steps: On the primary database, determine the current SCN by querying the V$DATABASE view: SQL … > SELECT CURRENT_SCN FROM V$DATABASE@BOSTON; CURRENT_SCN --------------------- 345162788 Make sure SQL
15.7.2 Converting a Failed Primary into a Logical Standby Using RMAN Backups → want to recover the failed primary database: SQL> SELECT APPLIED_SCN RECOVERY_SCN FROM V … $LOGSTDBY_PROGRESS; Also on the new primary database, determine the SCN to use in dealing with archive logs, as … PENDING_ROLE_CHANGE_TASKS FROM V$DATABASE; After a status of NONE has been returned, run the following query to
Part V Distributed Database Management → You can manage a distributed database environment.
Part V Oracle Instance Architecture → This 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
PL/SQL Functions that SQL Statements Can Invoke → Packages 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,
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
Part V Optimizer Statistics → The 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
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
11.2 Controlling User Access to Tables in a Logical Standby Database → RESTART_SCN column of V$LOGSTDBY_PROGRESS view. Upon restarting, SQL Apply starts mining redo records that
D PL/SQL Reserved Words and Keywords → can 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
Formal and Actual Subprogram Parameters → SUBTYPE 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