Oracle International Corporation

Chandrajith Ramachandran Unnithan

Wilson Wai Shun Chan

Tak Fung Wang

Wai Shun Wilson Chan

Carol L Colrain

Michael Zoll

Yu Kin Ho

Dungara Ram Choudhary

Andrew Stuart Ingham

Troy Anthony

Francisco Rafael Flores Michel

Walter Battistella

Techniques are provided for determining access affinity between services in a database cluster, and for placing workload of those services based, at least in part, on the access affinity. The techniques involve generating access records that indicate when sessions that are associated with each service operate on data blocks that were accessed by another session that is associated with another service. Access affinity information is generated based on the access records, where the access affinity information indicates access affinity (e.g. conflict scores) between each pair of services. The cluster then selects which node is to perform the work of a given session based on the access affinity information and the service associated with the session.

Methods and systems for conflict detection and mitigation between services in an autonomous database cloud environment

Disclosed is a method, a computer program product, and a computer system for implementing automatic connection load balancing of database connections between instances of a cluster. Load imbalances are detected globally in the cluster, and can be corrected autonomously by the local instances. The local controller/orchestrator detects the imbalance, computes a target for the instance, and makes any necessary adjustments on the instance, where a server marks the connections to redistribute, and then implements draining and/or planned failover to move sessions.

Automatic connection load balancing between instances of a cluster

Disclosed is a system, method, and computer program product to handle unresponsive reader instances in a database system. A timeout-based invalidation and suspension approach is provided that addresses the problem of unresponsive read-only instances.

Handling of unresponsive read only instances in a reader farm system

According to one aspect of the invention, a read-write instance of a multiple-instance database system receives a database statement for execution. The multiple-instance database system comprises a database shared by a plurality read-mostly instances that request only read access to a plurality of user database objects in the database and a plurality of read-write instances that request both read access and write access to the plurality of user database objects. The read-write instance selects one or more read-mostly instances, in the plurality of read-mostly instances, to perform one or more operations that require no write access to the plurality of user data objects.

Read mostly instances

Growing community of inventors

Union City, CA, United States of America

Chandrajith Ramachandran Unnithan