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 DBA_APPLY


1 to 20 of 33 results. Previous page Prev  Next next page


Database Reference, 12c Release 1 (12.1)

DBA_APPLY

4.49 DBA_APPLYDBA_APPLY displays information about all apply processes in the database. Its columns are the same as those in ALL_APPLY. See Also: \" ALL_APPLY \"

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

Oracle Streams Tags

Displaying the Default Tag Value for Each Apply Processthe APPLY_TAG value in the DBA_APPLY data dictionary view. For example, to get the hexadecimal value … A30 SELECT APPLY_NAME, APPLY_TAG FROM DBA_APPLY; Your output looks similar to the following: Apply

Streams Extended Examples, 12c Release 1 (12.1)

Single-Source Heterogeneous Replication Example

Step 8   Grant the hr User Execute Privilege on the Apply Process Rule SetDBA_APPLY WHERE APPLY_NAME='APPLY'; DBMS_RULE_ADM.GRANT_OBJECT_PRIVILEGE( privilege

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Displaying the Message Handler for Each Apply ProcessAPPLY_NAME, MESSAGE_HANDLER FROM DBA_APPLY WHERE MESSAGE_HANDLER IS NOT NULL; Your output looks

Streams Extended Examples, 12c Release 1 (12.1)

Single-Source Heterogeneous Replication Example

Step 14   Grant the hr User Execute Privilege on the Apply Process Rule SetDBA_APPLY WHERE APPLY_NAME='APPLY_DBS2'; DBMS_RULE_ADM.GRANT_OBJECT_PRIVILEGE( privilege

Streams Extended Examples, 12c Release 1 (12.1)

Single-Source Heterogeneous Replication Example

Step 8   Grant the hr User Execute Privilege on the Apply Process Rule SetDBA_APPLY WHERE APPLY_NAME='APPLY'; DBMS_RULE_ADM.GRANT_OBJECT_PRIVILEGE( privilege

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Displaying the DDL Handler for Each Apply ProcessSELECT APPLY_NAME, DDL_HANDLER FROM DBA_APPLY; Your output looks similar to the following: Apply

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_XSTREAM_ADM

ENABLE_GG_XSTREAM_FOR_STREAMS ProcedureStreams: ALL_APPLY DBA_APPLY ALL_CAPTURE DBA_CAPTURE A license for the Oracle GoldenGate product is

Streams Concepts and Administration, 12c Release 1 (12.1)

Troubleshooting Apply

Is the Apply Process Enabled?enabled, disabled, or aborted by querying the DBA_APPLY data dictionary view. For example, to check … DBA_APPLY WHERE APPLY_NAME = 'APPLY'; If the apply process is disabled, then your output looks similar to … , restart the apply process. To determine why an apply process aborted, query the DBA_APPLY data … , STATUS_CHANGE_TIME,

Database Reference, 12c Release 1 (12.1)

ALL_APPLY

2.11 ALL_APPLYaccessible to the current user. Related View DBA_APPLY displays information about all apply processes in the … : \" DBA_APPLY \" Oracle Database PL/SQL Packages and Types Reference for more information about the

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Determining the Queue, Rule Sets, and Status for Each Apply ProcessAPPLY_NAME, QUEUE_NAME, RULE_SET_NAME, NEGATIVE_RULE_SET_NAME, STATUS FROM DBA_APPLY; Your output looks … query the ERROR_NUMBER and ERROR_MESSAGE columns in the DBA_APPLY data dictionary view to determine … ERROR_NUMBER and ERROR_MESSAGE columns in the DBA_APPLY data dictionary view are not related to the

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

Migrating Advanced Replication to Oracle Streams

Step 2   Start the Apply Processes at Each Siteconnected as the Oracle Streams administrator: SELECT APPLY_NAME FROM DBA_APPLY; When you know the

Streams Concepts and Administration, 12c Release 1 (12.1)

Troubleshooting Apply

Does the Apply Process Apply Captured LCRs?messages applied by an apply process by querying the DBA_APPLY data dictionary view. For example, to … ', 'Captured', 'NO', 'Messages from Persistent Queue') APPLY_CAPTURED FROM DBA_APPLY WHERE APPLY_NAME

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

Simple Oracle Streams Replication Configuration

To check the Oracle Streams replication configuration: enabled. To do so, query the STATUS column in the DBA_APPLY view. To replicate changes:  At one of the

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Displaying the Precommit Handler for Each Apply ProcessSELECT APPLY_NAME, PRECOMMIT_HANDLER, APPLY_CAPTURED FROM DBA_APPLY WHERE PRECOMMIT_HANDLER IS NOT

Streams Concepts and Administration, 12c Release 1 (12.1)

Troubleshooting Apply

Is a Custom Apply Handler Specified?DBA_APPLY_DML_HANDLERS and DBA_APPLY data dictionary views. See Also: \"Message Processing Options

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Displaying General Information About Each Apply ProcessHEADING 'Apply User' FORMAT A20 SELECT APPLY_NAME, APPLY_CAPTURED, APPLY_USER FROM DBA_APPLY; Your

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Apply Processes

Displaying Information About the Reader Server for Each Apply Process) PROCESS_NAME, r.STATE, r.TOTAL_MESSAGES_DEQUEUED FROM V$STREAMS_APPLY_READER r, V$SESSION s, DBA_APPLY ap

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Oracle Streams Queues and Propagations

Viewing the Apply Processes Dequeuing Messages from Each Buffered Queue$BUFFERED_SUBSCRIBERS s, DBA_APPLY a WHERE q.QUEUE_ID = s.QUEUE_ID AND s.SUBSCRIBER_ADDRESS IS NULL AND

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring an Oracle Streams Environment

Table 22-1 Oracle Streams Static Data Dictionary ViewsALL_ Views DBA_ Views USER_ Views ALL_APPLY DBA_APPLY N/A ALL_APPLY_CHANGE_HANDLERS