Intelligent flood control management

• US 9,128,895 B2
• Filed: 02/19/2009
• Issued: 09/08/2015
• Est. Priority Date: 02/19/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Chan, Wilson, Pruscino, Angelo, Wang, Tak Fung, Hsu, Cheng-Lu
• Primary Examiner(s): TRUONG, LAN DAI T
• Application Number:
  US12/389,306
• Publication Number:
  US 20100211681A1
• Time in Patent Office: 2,392 Days
• Field of Search: 709/226, 709/212, 709/213, 709/214, 709/215, 709/227, 709/229, 709/216
• US Class Current: 1/1
• CPC Class Codes: G06F 15/173 using an interconnection network, e.g. matrix, shuffle, pyramid, star, snowflake
• CPC Class Codes: G06F 2209/5021 Priority
• CPC Class Codes: G06F 2209/508 Monitor
• CPC Class Codes: G06F 9/5011 the resources being hardware resources other than CPUs, Servers and Terminals

Abstract

Described herein are techniques for dynamically monitoring and managing resource usages of processes running on a node in a multi-node database system. High resource usages of processes can be proactively detected and alleviated, thereby making such a node to perform significantly better than otherwise.

Claims

1. A computer-implemented method, comprising:

monitoring a plurality of resource usages on a node;

granting to a plurality of database processes, by a resource control mechanism of the node, one or more locks, each lock of said one or more locks granting access to one or more specified shared data blocks of a database;

determining whether a resource usage in the plurality of resource usages exceeds a resource usage threshold; and

when the resource usage in the plurality of resource usages exceeds the resource usage threshold, implementing one or more resource usage reduction policies, by the resource control mechanism, to restrict access to one or more particular shared data blocks of the database by delaying or denying one or more requested locks corresponding to the one or more particular shared data blocks;

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

2. The computer-implemented method of claim 1, wherein the plurality of resource usages includes a resource usage selected from network bandwidth usage, memory usage and CPU usage.

3. The computer-implemented method of claim 1, wherein implementing the one or more resource usage reduction policies comprises prioritizing specific processes of the plurality of database processes based on one or more secured locks already granted to the specific processes by the resource control mechanism.

4. The computer-implemented method of claim 1, wherein implementing the one or more resource usage reduction policies comprises reducing input operations and output operations between the plurality of database processes by storing a plurality of messages in at least one buffer and sending messages stored in a selected buffer of the at least one buffer in a single physical message.

5. The computer-implemented method recited in claim 1, wherein the one or more locks comprise one or more exclusive write latches.

6. The computer-implemented method of claim 1, wherein implementing the one or more resource usage reduction policies comprises rejecting requests for new database connections to the database.

7. The computer-implemented method of claim 1, wherein implementing the one or more resource usage reduction policies comprises prioritizing specific processes of the plurality of database processes based on whether latches granted to the specific processes are for data blocks in high usage regions.

8. The computer-implemented method of claim 1, wherein implementing the one or more resource usage reduction policies comprises terminating a specific process requesting a latch from the resource control mechanism.

9. The computer-implemented method of claim 1, wherein the plurality of resource usages comprises at least one database-specific resource usage, wherein monitoring the at least one database-specific resource usage comprises analyzing database-specific resource usage data generated by database system software deployed on the node.

10. The computer-implemented method of claim 1, wherein the plurality of resource usages comprises at least one database-specific resource usage,

wherein when the resource usage in the plurality of resource usages exceeds the resource usage threshold, the node transitions from a first operating state to a second operating state;

wherein the one or more resource usage reduction policies implemented by the resource control mechanism to restrict access to the one or more particular shared data blocks of the database are implemented in the second operating state.

11. A non-transitory computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform:

monitoring a plurality of resource usages on a node;

granting to a plurality of database processes, by a resource control mechanism of the node, one or more locks, each lock of said one or more locks granting access to one or more specified shared data blocks of a database;

determining whether a resource usage in the plurality of resource usages exceeds a resource usage threshold; and

when the resource usage in the plurality of resource usages exceeds the resource usage threshold, implementing one or more resource usage reduction policies, by the resource control mechanism, to restrict access to one or more particular shared data blocks of the database by delaying or denying one or more requested locks corresponding to the one or more particular shared data blocks.

12. The non-transitory computer-readable storage medium of claim 11, wherein the plurality of resource usages includes a resource usage selected from network bandwidth usage, memory usage and CPU usage.

13. The non-transitory computer-readable storage medium of claim 11, wherein implementing the one or more resource usage reduction policies comprises prioritizing specific processes of the plurality of database processes based on one or more secured locks already granted to the specific processes by the resource control mechanism.

14. The non-transitory computer-readable storage medium of claim 11, wherein implementing the one or more resource usage reduction policies comprises reducing input operations and output operations between the plurality of database processes by storing a plurality of messages in at least one buffer and sending messages stored in a selected buffer of the at least one buffer in a single physical message.

15. The non-transitory computer-readable storage medium recited in claim 11, wherein the one or more locks comprise one or more exclusive write latches.

16. The non-transitory computer-readable storage medium of claim 11, wherein implementing the one or more resource usage reduction policies comprises rejecting requests for new database connections to the database.

17. The non-transitory computer-readable storage medium of claim 11, wherein implementing the one or more resource usage reduction policies comprises prioritizing specific processes of the plurality of database processes based on whether latches granted to the specific processes are for data blocks in high usage regions.

18. The non-transitory computer-readable storage medium of claim 11, wherein implementing the one or more resource usage reduction policies comprises terminating a specific process requesting a latch from the resource control mechanism.

19. The non-transitory computer-readable storage medium of claim 11, wherein the plurality of resource usages comprises at least one database-specific resource usage, wherein monitoring the at least one database-specific resource usage comprises analyzing database-specific resource usage data generated by database system software deployed on the node.

20. The non-transitory computer-readable storage medium of claim 11, wherein the plurality of resource usages comprises at least one database-specific resource usage,

wherein the one or more sequences of instructions include instructions which, when executed by the one or more processors, causes the one or more processors to perform:

when the resource usage in the plurality of resource usages exceeds the resource usage threshold, transitioning the node from a first operating state to a second operating state;

wherein the one or more resource usage reduction policies implemented by the resource control mechanism to restrict access to the one or more particular shared data blocks of the database are implemented in the second operating state.