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 automatic workload management


1 to 20 of 1351 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Oracle Real Application Clusters

Overview of Automatic Workload ManagementAutomatic 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Overview of Automatic Workload ManagementAutomatic 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

4 Introduction to Automatic Workload Managementtopics: Overview of Automatic Workload Management Automatic Workload Repository Service Deployment … Automatic Workload Repository Service Thresholds and Alerts

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Managing Unplanned OutagesAutomatic 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.

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Oracle Clients That Are Integrated with Fast Application NotificationOracle 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Example of Services and Thresholds AlertsTo 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Fast Application NotificationThis 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\"

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Application High Availability with Services and FANOracle 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Enabling ODP.NET Clients to Receive FAN High Availability EventsOracle 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Administering Services with the PL/SQL DBMS_SERVICE Packagegoal sets the automatic workload management goal directive to service quality or throughput dtp is

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Fast Application Notification High Availability EventsTable 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Using Fast Application Notification CalloutsFAN 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Load Balancing AdvisoryThis 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Enabling Oracle Call Interface Clients for Fast Connection FailoverOCI 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,

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Enabling Event Notification for Connection Failures in Oracle Real Application ClustersEvent 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Service Thresholds and AlertsService 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Connection Load Balancingprocessing, even if the workload changes over time. Services simplify the deployment of TAF. You can

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Managing Planned OutagesFor 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.

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Load Balancing Advisory FAN EventsThe 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

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Introduction to Automatic Workload Management

Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory EventsUse 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,