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

1 to 14 of 14 results.

Database Reference, 12c Release 1 (12.1)


1.8 AQ_TM_PROCESSESModifiable in a PDB No Range of values 0 and higher Basic No AQ_TM_PROCESSES controls time monitoring on … leave the AQ_TM_PROCESSES parameter unspecified and let the system autotune. The default value for … AQ_TM_PROCESSES is used if the client does not explicitly set a value for the parameter in the … Coordinator, then you must

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

Troubleshooting Apply

Is the AQ_TM_PROCESSES Initialization Parameter Set to Zero?The AQ_TM_PROCESSES initialization parameter controls time monitoring on queue messages and … later, the database automatically controls these activities when the AQ_TM_PROCESSES initialization … satisfy the apply process rule set s in the apply process's queue, then ensure that the AQ_TM_PROCESSES … Database Advanced Queuing

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

Managing Optimizer Statistics: Basic Topics

You can monitor statistics gathering jobs using data dictionary views.-------------------------------- ----------- ----- _high_priority_processes string VKTM aq_tm_processes integer 1 db_writer_processes

Database Reference, 12c Release 1 (12.1)

Parameters by Functional Category


Database Reference, 12c Release 1 (12.1)

Modifiable Parameters

1.4.2 Modifiable Parametersfollowing initialization parameters can be changed with ALTER SYSTEM: AQ_TM_PROCESSES

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

Troubleshooting Apply

33 Troubleshooting ApplyCustom Apply Handler Specified? Is the AQ_TM_PROCESSES Initialization Parameter Set to Zero? Does the

Database Advanced Queuing User's Guide, 12c Release 1 (12.1)

Basic Components

Queue Monitor Processesset AQ_TM_PROCESSES when Oracle Database AQ or Streams is used. If a value is specified, that value is … different from what was specified by AQ_TM_PROCESSES. No separate API is needed to disable or enable … the background processes. This is controlled by setting AQ_TM_PROCESSES to zero or nonzero. Oracle … recommends, however,

Database Reference, 12c Release 1 (12.1)

Background Processes

F Background Processesthat if the AQ_TM_PROCESSES initialization parameter is set to 0, this process will not start. The … database writes the following message to the alert log: WARNING: AQ_TM_PROCESSES is set to 0. System

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents


Database Error Messages, 12c Release 1 (12.1)

ORA-24280 to ORA-28709

ORA-25336: Cannot contact instance string during Streams AQ operationaq_tm_processes to a non-zero value. If the problem persists, contact Oracle Support Services.

Database Workspace Manager Developer's Guide, 12c Release 1 (12.1)

Workspace Manager Events

2.4.5 Asynchronous Notificationinit.ora parameters should be: aq_tm_processes = 1 job_queue_processes = 2 Example 2-5 registers for … parameters should be set as follows. rem aq_tm_processes = 1 rem job_queue_processes = 2 rem The user

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

Streams Concepts and Administration - Contents

Contentsthe Messages to be Applied? Is a Custom Apply Handler Specified? Is the AQ_TM_PROCESSES

Database Advanced Queuing User's Guide, 12c Release 1 (12.1)

Introduction to Oracle Database Advanced Queuing

Other Oracle Database Advanced Queuing FeaturesAQ_TM_PROCESSES. Beginning with 10 g Release 1 (10.1), time management and many other background processes … automatically and tuned constantly, you are saved the trouble of setting it with AQ_TM_PROCESSES. Although … it is no longer necessary to set init.ora parameter AQ_TM_PROCESSES, it is still supported. If you do … disable

Database High Availability Best Practices, 12c Release 1 (12.1)

 Configuring Oracle Data Guard

8.5.1 Oracle Data Guard Switchovers Best PracticesAQ_TM_PROCESSES parameter to 0. Cancel any specified apply delay by using the NODELAY keyword to stop and