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 (22.214.171.124) New Features Oracle Automatic Storage … Management 11 g Release 2 (126.96.36.199) 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
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
Administering Services → You can create and administer services with Oracle Enterprise Manager and the SRVCTL utility. The following sections describe how to perform service-related tasks using these tools: Overview of Service Administration Administering Services with Oracle Enterprise Manager Administering Services with SRVCTL Note: You can also use the DBMS_SERVICE package to create or modify services and service attributes,
Using DTP Services with Oracle RAC → … Choose different DTP services for different distributed transactions to balance the workload among … Database Advanced Application Developer's Guide for more information about transaction branch management in Oracle RAC
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\"
Fast Application Notification High Availability Events → Table 5-1 lists the FAN event types and Table 5-2 describes name-value pairs for the event parameters. The event type is always the first entry and the timestamp is always the last entry, as in the following example: FAN event type: SERVICEMEMBER VERSION=1.0 service=fantest database=ractest instance=rac1host=node01 status=up reason=FAILURE card=1 timestamp=2010-07-02 22:06:02
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
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
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\"
Measuring Performance by Service Using the Automatic Workload Repository → sessions are anonymous and shared. The Automatic Workload Repository (AWR) maintains performance
Example of Services and Thresholds Alerts → In this scenario, you need to check the thresholds for the payroll service. You can use the AWR report to get this information. You should compare the results from reports run over several successive intervals during which time the system is running optimally. For example, assume that for servers accessed by a payroll application, the AWR report runs each Thursday during the peak usage times of 1:00
Connection Load Balancing → Oracle Net Services provides the ability to balance client connections across the instances in an Oracle RAC configuration. There are two types of load balancing that you can implement: client-side and server-side load balancing. Client-side load balancing balances the connection requests across the listeners. With server-side load balancing, the SCAN listener directs a connection request to the best
Service Deployment Options → This section describes the following service deployment topics: Using Oracle Services Service Characteristics Service Usage in an Oracle RAC Database Service Usage in an Oracle RAC Database Default Service Connections
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
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
Service Usage in an Oracle RAC Database → by Service with AWR The metric data generated by Automatic Workload Repository (AWR) is organized
Enabling ODP.NET Clients to Receive FAN High Availability Events → 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 and ODP.NET proactively removes connections that are no longer valid. ODP.NET establishes additional connections to existing Oracle RAC instances if the removal of invalid connections