Embedded performance monitoring of a DBMS

Patent metadata

Field	Value
Publication number	US-10218591-B2
Application number	US-201414312582-A
Country	US
Kind code	B2
Filing date	Jun 23, 2014
Priority date	Jun 23, 2014
Publication date	Feb 26, 2019
Grant date	Feb 26, 2019

Abstract

Embedded Performance Monitoring is an “out-of-box” approach for performance monitoring of a DBMS. Performance monitoring of a DBMS is achieved through use of a browser to access the DBMS once a DBMS is installed and configured. The approach exploits a DBMS configured with the native capability to provide performance monitoring data and software via a browser. To retrieve and use the performance monitoring data from the DBMS, a browser executes software downloaded to the browser from the DBMS using web-based technologies.

First claim

What is claimed is:

1. A computer-implemented method, comprising steps of:
a DBMS receiving an HTTP request from a monitoring client for performance monitoring data related to the DBMS; and
in response to receiving said HTTP request:
retrieving performance metrics of the DBMS through a shared database session from a shared pool of sessions of the DBMS;
based at least in part on the performance metrics, said DBMS generating said performance monitoring data that includes: performance information regarding one or more database statements executed by said DBMS, performance information regarding overall system performance of said DBMS, or performance information regarding one or more database sessions of said DBMS; and
said DBMS transmitting said performance monitoring data to said monitoring client.

2. The method of claim 1 , further comprising:
in response to receiving said HTTP request, assigning the shared database session from the shared pool of sessions through which to retrieve the performance metrics from native components of the DBMS.

3. The method of claim 1 , wherein generating said performance monitoring data includes generating said performance monitoring data in a presentation-free format.

4. The method of claim 1 , further comprising:
said DBMS downloading native client-side components to said monitoring client, said native client-side components being configured to decompress data compressed by said DBMS; and
in response to receiving said HTTP request:
said DBMS compressing said performance monitoring data.

5. The method of claim 4 , wherein said DBMS downloading native client-side components is performed in response to receiving said HTTP request.

6. The method of claim 1 , wherein generating said performance monitoring data includes generating said performance monitoring data in a presentation-free format, further comprising:
said DBMS downloading native client-side components to said monitoring client, said native client-side components being configured to generate a presentation of particular performance information based on said performance monitoring data.

7. The method of claim 6 , wherein said DBMS downloading the native client-side components is performed in response to receiving said HTTP request.

8. The method of claim 6 , wherein the native client-side components are configured to cause a browser to display the particular information about at least one of:
the performance information regarding the one or more database sessions of said DBMS,
the performance information regarding the one or more database statements executed by said DBMS, and
the performance information regarding overall system performance of said DBMS.

9. The method of claim 1 , wherein said monitoring client comprises a browser.

10. The method of claim 1 , wherein said DBMS comprises one or more database server hosts, wherein said monitoring client is hosted on a computer system different than any of said one or more database server hosts, wherein said DBMS receiving said HTTP request from said monitoring client includes said DBMS receiving said HTTP request from said monitoring client over a network.

11. The method of claim 1 , further comprising:
said DBMS downloading native client-side components to said monitoring client to process said performance monitoring data for presentation on said monitoring client.

12. One or more non-transitory storage media storing a set of instructions which, when executed by one or more computing devices, causes:
a DBMS receiving an HTTP request from a monitoring client for performance monitoring data related to the DBMS; and
in response to receiving said HTTP request:
retrieving performance metrics of the DBMS through a shared database session from a shared pool of sessions of the DBMS;
based at least in part on the performance metrics, said DBMS generating said performance monitoring data that included: performance information regarding one or more database statements executed by said DBMS, performance information regarding overall system performance of said DBMS, or performance information regarding one or more database sessions of said DBMS; and
said DBMS transmitting said performance monitoring data to said monitoring client.

13. The one or more non-transitory storage media of claim 12 , the set of instructions comprising instructions, which when executed by the one or more computing devices cause:
in response to receiving said HTTP request, assigning the shared database session from the shared pool of sessions through which to retrieve the performance metrics from native components of the DBMS.

14. The one or more non-transitory storage media of claim 12 , wherein generating said performance monitoring data includes generating said performance monitoring data in a presentation-free format.

15. The one or more non-transitory storage media of claim 12 , the set of instructions comprising instructions, which when executed by the one or more computing devices cause:
said DBMS downloading native client-side components to said monitoring client, said native client-side components being configured to decompress data compressed by said DBMS; and
in response to receiving said HTTP request:
said DBMS compressing said performance monitoring data.

16. The one or more non-transitory storage media of claim 15 , wherein said DBMS downloading native client-side components is performed in response to receiving said HTTP request.

17. The one or more non-transitory storage media of claim 12 , the set of instructions comprising instructions, which when executed by the one or more computing devices cause:
said DBMS downloading native client-side components to said monitoring client, said native client-side components being configured to generate a presentation of particular performance information based on said performance monitoring data.

18. The one or more non-transitory storage media of claim 17 , wherein said DBMS downloading the native client-side components is performed in response to receiving said HTTP request.

19. The one or more non-transitory storage media of claim 17 , wherein the native client-side components are configured to cause a browser to display the particular information about at least one of:
the performance information regarding the one or more database sessions of said DBMS,
the performance information regarding the one or more database statements executed by said DBMS, and
the performance information regarding overall system performance of said DBMS.

20. The one or more non-transitory storage media of claim 12 , wherein said monitoring client comprises a browser.

21. The one or more non-transitory storage media of claim 12 , wherein said DBMS comprises one or more database server hosts, wherein said monitoring client is hosted on a computer system different than any of said one or more database server hosts, wherein said DBMS receiving said HTTP request from said monitoring client includes said DBMS receiving said HTTP request from said monitoring client over a network.

Assignees

• Oracle Int Corp

Inventors

• Yagoub Khaled
• Grant Cecilia Gervasio
• Xie Yuan
• Huo Jinye
• Dageville Benoit
• Munir Abdul

Classifications

• H04L67/025 Primary

  for remote control or remote monitoring of applications · CPC title

• G06F17/30306

  Physics · mapped topic

• H04L43/08 Primary

  Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters · CPC title

• G06F16/217

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• H04L43/0817

  by checking functioning · CPC title