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
1.8 AQ_TM_PROCESSES → Modifiable 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
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
You can monitor statistics gathering jobs using data dictionary views. → -------------------------------- ----------- ----- _high_priority_processes string VKTM aq_tm_processes integer 1 db_writer_processes
1.4.1 Parameters by Functional Category → AQ_TM_PROCESSES AWR_SNAPSHOT_TIME_OFFSET ASM_PREFERRED_READ_FAILURE_GROUPS COMPATIBLE
1.4.2 Modifiable Parameters → following initialization parameters can be changed with ALTER SYSTEM: AQ_TM_PROCESSES
33 Troubleshooting Apply → Custom Apply Handler Specified? Is the AQ_TM_PROCESSES Initialization Parameter Set to Zero? Does the
Queue Monitor Processes → set 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,
F Background Processes → that 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
Contents → ACTIVE_INSTANCE_COUNT 1.8 AQ_TM_PROCESSES 1.9 ARCHIVE_LAG_TARGET 1.10 ASM_DISKGROUPS 1.11 ASM_DISKSTRING 1.12
ORA-25336: Cannot contact instance string during Streams AQ operation → aq_tm_processes to a non-zero value. If the problem persists, contact Oracle Support Services.
2.4.5 Asynchronous Notification → init.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
Contents → the Messages to be Applied? Is a Custom Apply Handler Specified? Is the AQ_TM_PROCESSES
Other Oracle Database Advanced Queuing Features → AQ_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
8.5.1 Oracle Data Guard Switchovers Best Practices → AQ_TM_PROCESSES parameter to 0. Cancel any specified apply delay by using the NODELAY keyword to stop and