Real-time automatic database diagnostic monitor

Patent metadata

Field	Value
Publication number	US-9582367-B2
Application number	US-201213721895-A
Country	US
Kind code	B2
Filing date	Dec 20, 2012
Priority date	Oct 3, 2012
Publication date	Feb 28, 2017
Grant date	Feb 28, 2017

Abstract

A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.

First claim

What is claimed is:

1. A method for obtaining data items from a database host comprising:
receiving an indication that a database on the database host is unresponsive;
receiving, from a management server via a diagnostic connection, a first request for a first plurality of organized data items;
sending a first query, using a first interface, to a shared global area (SGA) stored within a memory on the database host for the first plurality of organized data items;
receiving, from the management server via a normal connection, a second request for a second plurality of organized data items;
sending a second query, using a second interface, to the SGA on the database host for the second plurality of organized data items;
retrieving, from the SGA on the database host, a first plurality of data items in response to the first query;
retrieving, from the SGA on the database host, a second plurality of data items in response to the second query;
converting the first plurality of data items into the first plurality of organized data items;
converting the second plurality of data items into the second plurality of organized data items;
sending the first plurality of organized data items to the management server;
sending the second plurality of organized data items to the management server;
analyzing the first plurality of organized data items and the second plurality of organized data items using a model of behavior of the database host to determine a process causing the database to be unresponsive; and
generating a recommendation based on the analysis.

2. The method of claim 1 , wherein the first plurality of organized data items and the second plurality of organized data items are in the same format.

3. The method of claim 1 , wherein the second interface is an SQL interface.

4. The method of claim 1 , wherein a data item in the first plurality of data items is an unlocked data item.

5. The method of claim 1 , wherein analyzing the first plurality of organized data items and the second plurality of organized data items to determine the process causing the database to be unresponsive is performed by a client system connected to the management server.

6. The method of claim 1 , wherein the model of behavior is based on how the process utilizes a resource selected from a group consisting of an interconnect and a shared pool.

7. The method of claim 1 , wherein the model of behavior is based on whether the memory has been over-allocated.

8. A system for obtaining data items from a database host comprising:
a memory comprising a shared global area (SGA), wherein the SGA comprises a first plurality of data items and a second plurality of data items;
a diagnostic connection agent configured to:
receive, from a management server via a diagnostic connection, a first request for a first plurality of organized data items;
send a first query, using a first interface, to the SGA for the first plurality of organized data items;
retrieve, from the SGA via the first interface, the first plurality of data items in response to the first query, wherein the first interface converts the first plurality of data items into the first plurality of organized data items; and
send the first plurality of organized data items to the management server; and

a database server configured to:
receive, from the management server via a normal connection, a second request for a second plurality of organized data items;
send a second query, using a second interface, to the SGA for the second plurality of organized data items;
retrieve, from the SGA via the second interface, the second plurality of data items in response to the second query, wherein the second interface converts the second plurality of data items into the second plurality of organized data items; and
send the second plurality of organized data items to the management server; and

a client configured to:
analyze the first plurality of organized data items and the second plurality of organized data items using a model of behavior of the database host to determine a process causing a database on the system to be unresponsive; and
generate a recommendation based on the analysis.

9. The system of claim 8 , wherein the first plurality of organized data items and the second plurality of organized data items are in the same format.

10. The system of claim 8 , wherein the second interface is an SQL interface.

11. The system of claim 8 , wherein a data item in the first plurality of data items is an unlocked data item.

12. The system of claim 8 , wherein the model of behavior is based on how the process utilizes a resource selected from a group consisting of an interconnect and a shared pool.

13. The system of claim 8 , wherein the model of behavior is based on whether the memory has been over-allocated.

14. A non-transitory computer readable medium comprising instructions that, when executed by a processor, perform a method for obtaining data items from a database host, the method comprising:
receiving an indication that a database on the database host is unresponsive;
receiving, from a management server via a diagnostic connection, a first request for a first plurality of organized data items;
sending a first query, using a first interface, to a shared global area (SGA) on the database host for the first plurality of organized data items;
receiving, from the management server via a normal connection, a second request for a second plurality of organized data items;
sending a second query, using a second interface, to the shared global area (SGA) on the database host for the second plurality of organized data items;
retrieving, from the shared global area (SGA) on the database host, a first plurality of data items in response to the first query;
retrieving, from the shared global area (SGA) on the database host, a second plurality of data items in response to the second query;
converting the first plurality of data items into the first plurality of organized data items; converting the second plurality of data items into the second plurality of organized data items;
sending the first plurality of organized data items to the management server;
sending the second plurality of organized data items to the management server; and
analyzing the first plurality of organized data items and the second plurality of organized data items using a model of behavior of the database host to determine a process causing the database to be unresponsive.

15. The non-transitory computer readable medium of claim 14 , wherein the first plurality of organized data items and the second plurality of organized data items are in the same format.

16. The non-transitory computer readable medium of claim 14 , wherein the second interface is an SQL interface.

17. The non-transitory computer readable medium of claim 14 , wherein a data item in the first plurality of data items is an unlocked data item.

18. The non-transitory computer readable medium of claim 14 , wherein the model of behavior is based on how the process utilizes a resource selected from a group consisting of an interconnect and a shared pool.

19. The non-transitory computer readable medium of claim 14 , wherein the model of behavior is based on whether the memory has been over-allocated.

Assignees

• Oracle Int Corp

Inventors

• An George
• Belknap Pete
• Shaft Uri
• Dageville Benoit
• Kini Ameet

Classifications

• G06F17/30424

  Physics · mapped topic

• G06F11/321

  Display for diagnostics, e.g. diagnostic result display, self-test user interface · CPC title

• G06F11/323

  Visualisation of programs or trace data · CPC title

• G06F11/1435 Primary

  using file system or storage system metadata · CPC title

• G06F16/245 Primary

  Query processing · CPC title