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
Overview of Automatic Workload Management → Automatic workload management enables you to manage the distribution of workloads to provide … runtime connection load balancing. Automatic workload management provides the greatest benefits to Oracle … that use Oracle Data Guard or Oracle Streams. Automatic workload
Overview of Automatic Workload Management → Automatic workload management enables you to manage workload distributions to provide optimal … performance for users and applications. Automatic workload management comprises the following: Services … — Oracle Database provides a powerful automatic
4 Introduction to Automatic Workload Management → topics: Overview of Automatic Workload Management Automatic Workload Repository Service Deployment … Automatic Workload Repository Service Thresholds and Alerts
Managing Unplanned Outages → Automatic Storage Management (ASM) processes, not just the database. You can use FAN callouts to report … recovery are automatic, including the restarting of the subsystems, such as the listener and the … faults to your fault management system and to initiate repair jobs.
Oracle Clients That Are Integrated with Fast Application Notification → Oracle has integrated FAN with many of the common client application environments that are used to connect to Oracle RAC databases. Therefore, the easiest way to use FAN is to use an integrated Oracle Client. You can use the Oracle Call Interface Session Pools, CMAN session pools, and JDBC and ODP.NET connection pools. Oracle Call Interface applications with TAF enabled should use FAN high availability
Example of Services and Thresholds Alerts → To check the thresholds for the payroll service, use the AWR report. You should record output from the report over several successive intervals during which time the system is running optimally. For example, assume that for an e-mail server, the AWR report runs each Monday during the peak usage times of 10:00 a.m. to 2:00 p.m. The AWR report would contain the response time, or DB time, and the CPU
Fast Application Notification → This section provides a detailed description of FAN under the following topics: Overview of Fast Application Notification Application High Availability with Services and FAN Managing Unplanned Outages Managing Planned Outages Fast Application Notification High Availability Events Using Fast Application Notification Callouts See Also: \"Oracle Clients That Are Integrated with Fast Application Notification\"
Application High Availability with Services and FAN → Oracle Database focuses on maintaining service availability. In Oracle RAC, Oracle services are designed to be continuously available with loads shared across one or more instances. The Oracle RAC high availability framework maintains service availability by using Oracle Clusterware and resource profiles. The Oracle RAC high availability framework monitors the database and its services and sends event
Enabling ODP.NET Clients to Receive FAN High Availability Events → Oracle Data Provider for.NET ( ODP.NET) connection pools can subscribe to notifications that indicate when nodes, services, and service members are down. After a DOWN event, Oracle Database cleans up sessions in the connection pool that go to the instance that stops and ODP.NET proactively disposes connections that are no longer valid. ODP.NET establishes connections to existing Oracle RAC instances
Administering Services with the PL/SQL DBMS_SERVICE Package → goal sets the automatic workload management goal directive to service quality or throughput dtp is
Fast Application Notification High Availability Events → Table 4-1 describes the FAN event record parameters and the event types, followed by name-value pairs for the event properties. The event type is always the first entry and the timestamp is always the last entry as in the following example: FAN event type: service_member Properties: version=1.0 service=ERP database=FINPROD instance=FINPROD3 host=node3 status=up Table 4-1 Event Record Parameters and
Using Fast Application Notification Callouts → FAN callouts are server-side executables that Oracle RAC executes immediately when high availability events occur. You can use FAN callouts to automate the following activities when events occur in a cluster configuration, such as: Opening fault tracking tickets Sending messages to pagers Sending e-mail Starting and stopping server-side applications Maintaining an uptime log by logging each event
Load Balancing Advisory → This section describes the load balancing advisory under the following topics: Overview of the Load Balancing Advisory Configuring Your Environment to Use the Load Balancing Advisory Load Balancing Advisory FAN Events
Enabling Oracle Call Interface Clients for Fast Connection Failover → OCI clients can enable Fast Connection Failover by registering to receive notifications about Oracle RAC high availability FAN events and respond when events occur. This improves the session failover response time in OCI and also removes terminated connections from connection and session pools. This feature works on Oracle Call Interface applications, including those that use TAF, connection pools,
Enabling Event Notification for Connection Failures in Oracle Real Application Clusters → Event notification is enabled if the SQL_ORCLATTR_FAILOVER_CALLBACK and SQL_ORCLATTR_FAILOVER_HANDLE attributes of the SQLSetConnectAttr function are set when a connection failure occurs in an Oracle RAC database environment. The symbols for the new attributes are defined in the sqora.h file. The SQL_ORCLATTR_FAILOVER_CALLBACK attribute is used to specify the address of a routine to call when a failure
Service Thresholds and Alerts → Service level thresholds enable you to compare achieved service levels against accepted minimum required levels. This provides accountability with respect to the delivery or the failure to deliver an agreed service level. The end goal is a predictable system that achieves service levels. There is no requirement to perform as fast as possible with minimum resource consumption; the requirement is to
Connection Load Balancing → processing, even if the workload changes over time. Services simplify the deployment of TAF. You can
Managing Planned Outages → For repairs, upgrades, and changes that require you to isolate one or more instances, Oracle RAC provides interfaces that relocate, disable, and enable services to minimize service disruption to application users. Once you complete the operation, you can return the service to normal operation. Due to dependencies, if you manually shutdown your database, then all of your services automatically stop.
Load Balancing Advisory FAN Events → The load balancing advisory FAN events provide metrics for load balancing algorithms. The easiest way to take advantage of these events is to use the runtime connection load balancing feature of an Oracle integrated client such as JDBC, ODP.NET, or Oracle Call Interface. Client applications can subscribe to these events directly by way of the ONS API. Table 4-3 describes the load balancing advisory
Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory Events → Use the following procedures to enable ODP.NET to receive FAN load balancing advisory events: Enable Advanced Queuing notifications by using the DBMS.SERVICE package, and by setting the GOAL and CLB_GOAL for the service as in the following example: EXECUTE DBMS_SERVICE.MODIFY_SERVICE (service_name => 'gl.us.oracle.com', failover_method => DBMS_SERVICE.FAILOVER_METHOD_BASIC, failover_type => DBMS_SERVICE.FAILOVER_TYPE_SELECT,