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 2451 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Oracle RAC

Overview of Automatic Workload ManagementAutomatic workload management enables you to manage the distribution of workloads to provide … , and runtime connection load balancing. Automatic workload management provides the greatest benefits … to Oracle RAC environments. You can, however, take advantage of automatic

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

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

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Automatic Storage Management Administrator's Guide - Contents

ContentsAccessibility Related Documents Conventions What's New in Oracle Automatic Storage Management? Oracle … Automatic Storage Management 11 g Release 2 (11.2.0.3) New Features Oracle Automatic Storage … Management 11 g Release 2 (11.2.0.2) New Features Oracle Automatic Storage

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

5 Introduction to Automatic Workload Managementthe following topics: Overview of Automatic Workload Management Automatic Workload Repository … enable more flexibility in the management of the workload using the database, Oracle Database enables … instances) the services are started on. If you are interested in greater

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Automatic Workload RepositoryThe Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics … services. The AWR ensures that the Oracle Clusterware workload management framework and the … Oracle Database Performance Tuning Guide for more information about the Automatic Workload

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Using Oracle ServicesTo manage workloads or a group of applications, you can define services that you assign to a particular application or to a subset of an application's operations. You can also group work by type under services. For example, online users can use one service, while batch processing can use another and reporting can use yet another service to connect to the database. Oracle recommends that all users

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Service CharacteristicsWhen you create new services for your database, you should define the automatic workload managementmanagement policy for a service to AUTOMATIC (the default), then the service starts automatically … Service Name Service Edition Service Management Policy Database Role for a Service

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Other Client-Side Connection FeaturesIn addition to client-side load balancing, Oracle Net Services include connection failover. If an error is returned from the chosen address in the list, Oracle Net Services tries the next address in the list until it is either successful or it has exhausted all addresses in its list. For SCAN, Oracle Net Services tries all three addresses before returning a failure to the client. EZConnect with SCAN

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Overview of the Load Balancing AdvisoryLoad balancing distributes work across all of the available Oracle RAC database instances. Oracle recommends that applications use persistent connections that span the instances that offer a particular service, such as when using connection pools. When using persistent connections, connections are created infrequently and exist for a long duration. Work comes into the system with high frequency, borrows

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Monitoring Load Balancing Advisory FAN EventsYou can use the following query against the internal queue table for load balancing advisory FAN events to monitor load balancing advisory events generated for an instance: SET PAGES 60 COLSEP '|' LINES 132 NUM 8 VERIFY OFF FEEDBACK OFF COLUMN user_data HEADING \"AQ Service Metrics\" FORMAT A60 WRAP BREAK ON service_name SKIP 1 SELECT TO_CHAR(enq_time, 'HH:MI:SS') Enq_time, user_data FROM sys.sys$service_metrics_tab

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Enabling JDBC Clients for Fast Connection FailoverEnabling Fast Connection Failover (FCF) for the Oracle JDBC Universal Connection Pool (UCP) enables the use of FAN high availability and load balancing advisory events. To use FAN, your application can use the JDBC development environment for either thick or thin JDBC clients. The Java Database Connectivity Oracle Call Interface (JDBC/OCI) driver connection pooling functionality is part of the JDBC

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory EventsUse the following procedures to enable ODP.NET clients or applications to receive FAN load balancing advisory events: Enable Advanced Queuing notifications by using SRVCTL, and set the connection load balancing goal as shown in the following example: srvctl modify service -d crm -s odpapp.example.com -q TRUE -j LONG Ensure Oracle Net Services is configured for connection load balancing. Grant permissions

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Benefits of DTP Services for XA TransactionsTo provide improved application performance with distributed transaction processing in Oracle RAC, you may want to take advantage of DTP services. Using DTP services, you can direct all branches of a distributed transaction to a single instance in the cluster. To load balance across the cluster, it is better to have several groups of smaller application servers with each group directing its transactions

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Configuring DTP ServicesTo create DTP services for distributed transaction processing, perform the following steps: Create a singleton service using Oracle Enterprise Manager or SRVCTL. For an administrator-managed database, define only one instance as the preferred instance. You can have as many available instances as you want, for example: srvctl add service -d crm -s xa_01.example.com -r RAC01 -a RAC02,RAC03 For a policy-managed

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Automatic Workload Repository Service Thresholds and AlertsService level thresholds enable you to compare actual service levels against required levels of service. This provides accountability for 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 meet the quality of

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

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 2 (11.2)

Introduction to Automatic Workload Management

Managing Unplanned OutagesOracle Automatic Storage Management (Oracle ASM) processes, not just the database. You can use FAN … and recovery are automatic, including the restarting of the subsystems, such as the listener and the … callouts to report faults to your fault management system and to initiate repair jobs.

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Managing Planned Outagesrestart the database, then you must set the management policy of the service to automatic. If you want … that were running on that instance are failed over to another instance if possible. See Also: \"Service Management Policy\"

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

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 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 as it occurs Relocating

Real Application Clusters Administration and Deployment Guide, 11g Release 2 (11.2)

Introduction to Automatic Workload Management

Enabling JDBC Clients for Runtime Connection Load BalancingUCP JDBC connection pools leverage the load balancing functionality provided by an Oracle RAC database. Runtime connection load balancing requires the use of an Oracle JDBC driver and an Oracle RAC database. Runtime connection load balancing requires that FCF is enabled and configured properly. See \"Configuring FCF for JDBC/OCI and JDBC Thin Driver Clients\". In addition, the Oracle RAC load balancing