Granted Patent B2

US 12,197,444 · App. 18/470,034 · Granted Jan 14, 2025

Inventors: Oleksiy Ignatyev (Belmont, CA); Mihail Mihaylov (Redwood Shores, CA)

Assignee: Oracle International Corporation

G06F16/24552G06F9/4494G06F16/2282G06F16/24539G06F16/2456G06F16/2471G06F16/9017

Abstract

Claims (62)

1. One or more non-transitory computer readable media comprising instructions which, when executed by one or more hardware processors, causes performance of operations comprising:

identifying a first plurality of executions of a first query during a first period of time;

comparing an execution time of each execution, of the first plurality of executions of the first query, to a first threshold value;

identifying a first subset of executions, of the first plurality of executions, with corresponding execution times that exceed the first threshold value;

determining whether a first number of executions, in the first subset of executions, exceeds a second threshold value;

responsive to determining that the first number of executions, in the first subset of executions, exceeds the second threshold value;

caching a first resource, used for execution of the first query, for a second period of time.

2. The one or more non-transitory computer readable media of claim 1 , wherein the operations further comprise:

identifying a second plurality of executions of a second query during the first period of time;

comparing an execution time of each execution, of the second plurality of executions of the second query, to a first threshold value;

identifying a second subset of executions, of the second plurality of executions, with corresponding execution times that exceed the first threshold value;

determining whether a second number of executions, in the second subset of executions, exceeds a second threshold value;

responsive at least to determining that the second number of executions, in the second subset of executions, does not exceed the second threshold value;

refraining from caching a second resource, used for execution of the second query, for the second period of time.

3. The non-transitory computer readable media of claim 1 , wherein the resource is a table.

4. The non-transitory computer readable media of claim 1 , wherein determining the execution time for a particular execution of the first plurality of executions of the first query comprises:

determining a time period between transmitting a request to execute the first query and receiving results from execution of the first query.

5. The non-transitory computer readable media of claim 1 , wherein a particular execution, of the first plurality of executions, is determined to be computationally expensive responsive to the execution time of the particular execution exceed the first threshold value.

6. The non-transitory computer readable media of claim 1 , wherein the operations further comprise storing a log record for the first subset of executions with corresponding execution times that exceed the first threshold value.

7. The non-transitory computer readable media of claim 1 , wherein first resource is stored further in response to determining that a cumulative execution time for the first subset of executions exceeds a third threshold value.

8. A method including operations comprising:

identifying a first plurality of executions of a first query during a first period of time;

comparing an execution time of each execution, of the first plurality of executions of the first query, to a first threshold value;

identifying a first subset of executions, of the first plurality of executions, with corresponding execution times that exceed the first threshold value;

determining whether a first number of executions, in the first subset of executions, exceeds a second threshold value;

responsive to determining that the first number of executions, in the first subset of executions, exceeds the second threshold value;

caching a first resource, used for execution of the first query, for a second period of time, wherein the method is executed by at least one device including a hardware processor.

9. The method of claim 8 , wherein the operations further comprise:

identifying a second plurality of executions of a second query during the first period of time;

comparing an execution time of each execution, of the second plurality of executions of the second query, to a first threshold value;

identifying a second subset of executions, of the second plurality of executions, with corresponding execution times that exceed the first threshold value;

determining whether a second number of executions, in the second subset of executions, exceeds a second threshold value;

responsive at least to determining that the second number of executions, in the second subset of executions, does not exceed the second threshold value;

refraining from caching a second resource, used for execution of the second query, for the second period of time.

10. The method of claim 8 , wherein the resource is a table.

11. The method of claim 8 , wherein determining the execution time for a particular execution of the first plurality of executions of the first query comprises:

determining a time period between transmitting a request to execute the first query and receiving results from execution of the first query.

12. The method of claim 8 , wherein a particular execution, of the first plurality of executions, is determined to be computationally expensive responsive to the execution time of the particular execution exceed the first threshold value.

13. The method of claim 8 , wherein the operations further comprise storing a log record for the first subset of executions with corresponding execution times that exceed the first threshold value.

14. The method of claim 8 , wherein first resource is stored further in response to determining that a cumulative execution time for the first subset of executions exceeds a third threshold value.

15. A system comprising:

at least one device including a hardware processor and memory storing instructions;

the hardware processor being configured to execute the instructions to perform operations comprising:

identifying a first plurality of executions of a first query during a first period of time;

comparing an execution time of each execution, of the first plurality of executions of the first query, to a first threshold value;

identifying a first subset of executions, of the first plurality of executions, with corresponding execution times that exceed the first threshold value;

determining whether a first number of executions, in the first subset of executions, exceeds a second threshold value;

responsive to determining that the first number of executions, in the first subset of executions, exceeds the second threshold value;

caching a first resource, used for execution of the first query, for a second period of time.

16. The system of claim 15 , wherein the operations further comprise:

identifying a second plurality of executions of a second query during the first period of time;

comparing an execution time of each execution, of the second plurality of executions of the second query, to a first threshold value;

identifying a second subset of executions, of the second plurality of executions, with corresponding execution times that exceed the first threshold value;

determining whether a second number of executions, in the second subset of executions, exceeds a second threshold value;

responsive at least to determining that the second number of executions, in the second subset of executions, does not exceed the second threshold value;

refraining from caching a second resource, used for execution of the second query, for the second period of time.

17. The system of claim 15 , wherein the resource is a table.

18. The system of claim 15 , wherein determining the execution time for a particular execution of the first plurality of executions of the first query comprises:

determining a time period between transmitting a request to execute the first query and receiving results from execution of the first query.

19. The system of claim 15 , wherein a particular execution, of the first plurality of executions, is determined to be computationally expensive responsive to the execution time of the particular execution exceed the first threshold value.

20. The system of claim 15 , wherein the operations further comprise storing a log record for the first subset of executions with corresponding execution times that exceed the first threshold value.

21. The system of claim 15 , wherein first resource is stored further in response to determining that a cumulative execution time for the first subset of executions exceeds a third threshold value.

Assignments (3)

Continuity (2)

References Cited (42)