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 … , and runtime connection load balancing. Automatic workload management provides the greatest benefits … to Oracle RAC environments. You can, however, take advantage of automatic
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
Contents → Accessibility Related Documents Conventions What's New in Oracle Automatic Storage Management? Oracle … Automatic Storage Management 11 g Release 2 (184.108.40.206) New Features Oracle Automatic Storage … Management 11 g Release 2 (220.127.116.11) New Features Oracle Automatic Storage
5 Introduction to Automatic Workload Management → the 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
Automatic Workload Repository → The 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
Using Oracle Services → To 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
Service Characteristics → When you create new services for your database, you should define the automatic workload management … management 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
Other Client-Side Connection Features → In 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
Overview of the Load Balancing Advisory → Load 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
Monitoring Load Balancing Advisory FAN Events → You 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
Enabling JDBC Clients for Fast Connection Failover → Enabling 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
Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory Events → Use 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
Benefits of DTP Services for XA Transactions → To 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
Configuring DTP Services → To 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
Automatic Workload Repository Service Thresholds and Alerts → Service 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
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
Managing Unplanned Outages → Oracle 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.
Managing Planned Outages → restart 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\"
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 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
Enabling JDBC Clients for Runtime Connection Load Balancing → UCP 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