INTELLIGENT FLOOD CONTROL MANAGEMENT

• US 20100211681A1
• Filed: 02/19/2009
• Published: 08/19/2010
• Est. Priority Date: 02/19/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Hsu, Cheng-Lu, Chan, Wilson, Pruscino, Angelo, Wang, Tak Fung
• Granted Patent: US 9,128,895 B2
• Time in Patent Office: Days
• US Class Current: 709/226
• 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;

determining whether one or more resource usages in the plurality of resource usages are high; and

in response to determining that one or more resource usages in the plurality of resource usages are high, implementing one or more resource usage reduction policies;

wherein the method is performed by a computer programmed to be a special purpose machine pursuant to instructions from program software.

2. A computer-implemented method as recited in claim 1, wherein monitoring a plurality of resource usages on a node in a multi-node system includes analyzing database-specific resource usage data generated by database system software deployed on the node.

3. A computer-implemented method as recited in claim 1, further comprising prioritizing a plurality of processes based on resource requirements that will be newly generated by individual processes in the plurality of processes.

4. A computer-implemented method as recited in claim 1, further comprising prioritizing a plurality of processes based on what resources individual processes have already secured, wherein the individual processes are in the plurality of processes.

5. A computer-implemented method as recited in claim 1, further comprising sending a plurality of messages in a single physical message that incurs a minimal number of I/O operations.

6. A computer-implemented method, comprising:

monitoring a plurality of resource usages on a node;

determining whether one or more resource usages in the plurality of resource usages are high; and

in response to determining that one or more resource usages in the plurality of resource usages are high, rejecting at least one request for a new session to be established on the node;

wherein the method is performed by a computer programmed to be a special purpose machine pursuant to instructions from program software.

7. A computer-implemented method as recited in claim 6, wherein monitoring a plurality of resource usages on a node in a multi-node system includes analyzing database-specific resource usage data generated by database system software deployed on the node.

8. A computer-implemented method as recited in claim 6, further comprising prioritizing a plurality of processes based on resource requirements that will be newly generated by individual processes in the plurality of processes.

9. A computer-implemented method as recited in claim 6, further comprising prioritizing a plurality of processes based on what resources individual processes have already secured, wherein the individual processes are in the plurality of processes.

10. A computer-implemented method as recited in claim 6, further comprising sending a plurality of messages in a single physical message that incurs a minimal number of I/O operations.

11. A 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;

determining whether one or more resource usages in the plurality of resource usages are high; and

in response to determining that one or more resource usages in the plurality of resource usages are high, implementing one or more resource usage reduction policies.

12. A computer-readable storage medium as recited in claim 11, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform analyzing database-specific resource usage data generated by database system software deployed on the node.

13. A computer-readable storage medium as recited in claim 11, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform prioritizing a plurality of processes based on resource requirements that will be newly generated by individual processes in the plurality of processes.

14. A computer-readable storage medium as recited in claim 11, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform prioritizing a plurality of processes based on what resources individual processes have already secured, wherein the individual processes are in the plurality of processes.

15. A computer-readable storage medium as recited in claim 11, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform sending a plurality of messages in a single physical message that incurs a minimal number of I/O operations.

16. A 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;

determining whether one or more resource usages in the plurality of resource usages are high; and

in response to determining that one or more resource usages in the plurality of resource usages are high, rejecting at least one request for a new session to be established on the node.

17. A computer-readable storage medium as recited in claim 16, wherein the plurality of resource usages includes a resource usage for memory on the node.

18. A computer-readable storage medium as recited in claim 16, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform prioritizing a plurality of processes based on resource requirements that will be newly generated by individual processes in the plurality of processes.

19. A computer-readable storage medium as recited in claim 16, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform prioritizing a plurality of processes based on what resources individual processes have already secured, wherein the individual processes are in the plurality of processes.

20. A computer-readable storage medium as recited in claim 16, wherein the one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to further perform sending a plurality of messages in a single physical message that incurs a minimal number of I/O operations.