Read mostly instances

• US 10,152,500 B2
• Filed: 03/14/2013
• Issued: 12/11/2018
• Est. Priority Date: 03/14/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Chan, Wilson Wai Shun, Unnithan, Chandrajith Ramachandran
• Primary Examiner(s): Obisesan, Augustine K.
• Application Number:
  US13/829,103
• Publication Number:
  US 20140279840A1
• Time in Patent Office: 2,098 Days
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

Abstract

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.

Claims

1. A multi-instance database system comprising one or more computing devices, the multi-instance database system comprising:

a database storing a plurality of user data objects;

a plurality of database server instances sharing direct access to the database;

wherein the plurality of database server instances comprises a plurality of read-write database server instances configured with read access and write access to the plurality of user data objects;

wherein the plurality of database server instances comprises a plurality of read-mostly database server instances configured with only read access to the plurality of user data objects; and

a read-write database server instance configured to;

select one or more read-mostly database server instances, in the plurality of read-mostly database server instances, to perform one or more operations that require no write access to the plurality of user data objects;

send, to a read-mostly database server instance of the one or more read-mostly database server instances, an execution plan for accessing the plurality of user data objects and a system change number (SCN) associated with the execution plan;

the read-mostly database server instance configured to execute the execution plan, wherein executing the execution plan comprises accessing one or more user data objects of the plurality of user data objects using the SCN.

2. The multi-instance database system of claim 1, wherein the one or more operations are among a plurality of operations to execute a database statement.

3. The multi-instance database system of claim 2, wherein the database statement is one of a database query statement, a data manipulation language (DML) statement, or a data definition language (DDL) statement.

4. The multi-instance database system of claim 1, wherein the read-write database server instance is further configured to select only one or more read-write database server instances in the plurality of read-write database server instances, to perform one or more second operations that require write access to the plurality of user data objects.

5. The multi-instance database system of claim 1, wherein none of the plurality of read-mostly database server instances is configured to be resource masters of resources in the database.

6. The multi-instance database system of claim 1, wherein none of the plurality of read-mostly database server instances is configured to receive a database statement from a user.

7. A method comprising:

a read-write database server instance of a multiple-instance database system receiving a database statement for execution, wherein the multiple-instance database system comprises a database shared by a plurality of read-mostly database server instances configured with only read access to a plurality of user database objects in the database and a plurality of read-write database server instances configured with both read access and write access to the plurality of user database objects; and

the read-write database server instance selecting one or more read-mostly database server instances, in the plurality of read-mostly database server instances, to perform one or more operations that require no write access to the plurality of user data objects;

sending, to a read-mostly database server instance of the one or more read-mostly database server instances, an execution plan for accessing the plurality of user database objects and a system change number (SCN) associated with the execution plan;

the read-mostly database server instance executing the execution plan, wherein executing the execution plan comprises accessing one or more user database objects of the plurality of user data objects using the SCN;

wherein the method is performed by one or more computing devices.

8. The method of claim 7, wherein the one or more operations are among a plurality of operations to execute a database statement.

9. The method of claim 8, wherein the database statement is one of a database query statement, a data manipulation language (DML) statement, or a data definition language (DDL) statement.

10. The method of claim 7, wherein the read-write database server instance is further configured to select one or more read-write database server instances in the plurality of read-write database server instances, to perform one or more second operations that require write access to the plurality of user data objects.

11. The method of claim 7, wherein none of the plurality of read-mostly database server instances is configured to be resource masters to resources of the database.

12. The method of claim 7, wherein none of the plurality of read-mostly database server instances is configured to receive a database statement from a user.

13. The method of claim 7, wherein the plurality of read-write database server instances and the plurality of read-mostly database server instances share direct access to the database.

14. One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause:

a read-write database server instance of a multiple-instance database system receiving a database statement for execution, wherein the multiple-instance database system comprises a database shared by a plurality of read-mostly database server instances configured with only read access to a plurality of user database objects in the database and a plurality of read-write database server instances configured with both read access and write access to the plurality of user database objects; and

the read-write database server instance selecting one or more read-mostly database server instances, in the plurality of read-mostly database server instances, to perform one or more operations that require no write access to the plurality of user data objects;

sending, to a read-mostly database server instance of the one or more read-mostly database server instances, an execution plan for accessing the plurality of user database objects and a system change number (SCN) associated with the execution plan;

the read-mostly database server instance executing the execution plan, wherein executing the execution plan comprises accessing one or more user database objects of the plurality of user data objects using the SCN.

15. The one or more media of claim 14, wherein the one or more operations are among a plurality of operations to execute a database statement.

16. The one or more media of claim 14, wherein the read-write database server instance is further configured to select one or more read-write database server instances in the plurality of read-write database server instances, to perform one or more second operations that require write access to the plurality of user data objects.

17. The one or more media of claim 14, wherein none of the plurality of read-mostly database server instances is configured to be resource masters of resources of the database.

18. The one or more media of claim 14, wherein none of the plurality of read-mostly database server instances is configured to receive a database statement from a user.

19. The one or more media of claim 14, wherein the plurality of read-write database server instances and the plurality of read-mostly database server instances share direct access to the database.