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
Propagation Subprograms → Table 22-7 Propagation Subprograms Subprograms Description ALTER_PROPAGATION_SCHEDULE Procedure … Alters parameters for a propagation schedule DISABLE_PROPAGATION_SCHEDULE Procedure Disables a … propagation schedule ENABLE_PROPAGATION_SCHEDULE Procedure Enables a previously disabled propagation … schedule SCHEDULE_PROPAGATION
Propagation Jobs → An Oracle Streams propagation is configured internally using Oracle Scheduler. Therefore, a … propagation job is a job that propagates message s from a source queue to a destination queue. Like other … Oracle Scheduler jobs, propagation jobs have an owner, and they use slave processes ( j nnn ) as … needed to execute jobs. The
Propagation Restrictions → for Queue-To-Queue Propagations See Also: \"Message Propagation Between Queues\"
Propagation Rules → A propagation either propagates or discards message s based on rule s that you define. For LCR s … . For user message s, you can create rules to control propagation behavior for specific types of … messages. You can place these rules in a positive rule set or a negative rule set used by the propagation … propagation,
LCR Propagation → In an Oracle Streams replication environment, a propagation typically propagates LCRs from a queue … queues. Figure 1-6 Propagation from a Source Queue to a Destination Queue Description of \"Figure 1-6 … Propagation from a Source Queue to a Destination Queue\" Even after an LCR is propagated by a … propagation
Set the Propagation Latency for Each Propagation → Propagation latency is the maximum wait, in seconds, in the propagation window for a message to be … propagated after it is enqueued. Set the propagation latency to an appropriate value for each … propagation in your Oracle Streams replication environment. The default propagation latency value is 60
Best Practices for Propagation Configuration → Propagations Set the Propagation Latency for Each Propagation Increase the SDU in a Wide Area Network for Better Network Performance
17 Best Practices for Propagation → environment. This chapter includes these topics: Best Practices for Propagation Configuration Best … Practices for Propagation Operation See Also: \"Best Practices for Oracle Real Application Clusters and Oracle Streams\"
Removing a Queue → You use the REMOVE_QUEUE procedure in the DBMS_STREAMS_ADM package to remove an existing ANYDATA queue. When you run the REMOVE_QUEUE procedure, it waits until any existing message s in the queue are consumed. Next, it stops the queue, which means that no further enqueues into the queue or dequeues from the queue are allowed. When the queue is stopped, it drops the queue. You can also drop the queue
Managing Oracle Streams Propagations and Propagation Jobs → A propagation propagates message s from an Oracle Streams source queue to an Oracle Streams … Propagation Stopping a Propagation Altering the Schedule of a Propagation Job Specifying the Rule Set for … a Propagation Adding Rules to the Rule Set for a Propagation Removing a Rule from
Altering the Schedule of a Propagation Job → To alter the schedule of an existing propagation job, use the ALTER_PROPAGATION_SCHEDULE procedure … propagation job for a queue-to-queue propagation and for a queue-to-dblink propagation. These examples … set the propagation job to propagate message s every 15 minutes (900 seconds), with each propagation
Removing a Rule from the Rule Set for a Propagation → You remove a rule from the rule set for an existing propagation by running the REMOVE_RULE … departments3 from the positive rule set of a propagation named strm01_propagation. BEGIN … DBMS_STREAMS_ADM.REMOVE_RULE( rule_name => 'departments3', streams_type => 'propagation', streams_name … for the propagation, not
Use Queue-to-Queue Propagations → A propagation can be queue-to-queue or queue-to-database link (queue-to-dblink). Use queue-to-queue … propagations whenever possible. A queue-to-queue propagation always has its own exclusive … propagation job to propagate messages from the source queue to the destination queue. Because each … propagation job
15 Managing Staging and Propagation → The following topics describe managing ANYDATA queue s and propagation s: Managing Queues Managing … Oracle Streams Propagations and Propagation Jobs Each task described in this chapter should be … specified otherwise. See Also: Chapter 3, \"Oracle Streams Staging and Propagation\" \"Configuring an … Propagations and Propagation
Enabling a User to Perform Operations on a Secure Queue → For a user to perform queue operations, such as enqueue and dequeue, on a secure queue, the user must be configured as a secure queue user of the queue. If you use the SET_UP_QUEUE procedure in the DBMS_STREAMS_ADM package to create the secure queue, then the queue owner and the user specified by the queue_user parameter are configured as secure users of the queue automatically. If you want to enable
Starting a Propagation → propagation. For example, the following procedure starts a propagation named strm01_propagation
Adding Rules to the Rule Set for a Propagation → To add rule s to the rule set of a propagation, you can run one of the following procedures … rule set for a propagation. The ADD_SUBSET_PROPAGATION_RULES procedure can add rules only to the … positive rule set for a propagation. This section contains these topics: Adding Rules to the Positive … Rule Set for a Propagation
Increase the SDU in a Wide Area Network for Better Network Performance → When using Oracle Streams propagation in a Wide Area Network (WAN), increase the session data unit … (SDU) to improve the propagation performance. The maximum value for SDU is 32K (32767). The SDU … advantage of an increased SDU for Oracle Streams propagation, the receiving side sqlnet.ora file must … parameters in the listener.ora
Best Practices for Propagation Operation → Propagations Sometimes, the propagation job for a propagation might become \"broken\" or fail to … propagation solves the problem. For example, to stop and restart a propagation named prop1, run the … parameter set to TRUE, and restart propagation. For example: BEGIN … DBMS_PROPAGATION_ADM.START_PROPAGATION(
Disabling a User from Performing Operations on a Secure Queue → You might want to disable a user from performing queue operations on a secure queue for the following reasons: You dropped a capture process or a synchronous capture, but you did not drop the queue that was used by the capture process or synchronous capture, and you do not want the user who was the capture user to be able to perform operations on the remaining secure queue. You dropped an apply process,