Visualizing-Oracle-Performance-Data-By-Graph

I finished a project about how to visualize oracle performance by graph in recent two months (2021.11 - 2021.12).

1. Introduction - What's VOPDBG?

In this section I'll share something with you about the introduction about visualizing oracle performance data by graph. Yes, as well-known as, VOPDBG is the combination of the first letter abbreviation for Visualizing Oracle Performance Data By Graph.

2. Oracle Performance Metrics

Here we primarily concentrate visualizeng the following oracle performance metrics.

• ASPAC (Active Sessions Per Activity Class)
  • acquire_aspac.sql
• ASPWC (Active Sessions Per Wait Class)
  • acquire_aspwc.sql
• AAS (Average Active Sessions)
  • acquire_aas_2.sql
• AASLC (Average Active Sessions & Logic CPUs)
  • acquire_logic_cpus_union_aas.sql
• ARP (Average Runnable Processes)
  • acquire_arp.sql
  • acquire_arp_2.sql
• CLC (Current Logons Count)
  • acquire_clc.sql
• COL (Current OS Load)
  • acquire_col.sql
• DT (DB Time)
  • acquire_dbtime.sql
• LFSSBR (Latency For Synchronous Single Block Reads)
  • acquire_assbrl.sql
• PRPWRS (Physical Reads and Physical Writes and Redo Size)
  • acquire_prps_union_pwps_union_rsps.sql
• TPRTPWTI (Total Physical Reads and Total Physical Writes and Total IO)
• UTPSLPS (User Transaction Per Second and Logons Per Second)
  • acquire_lps_union_tps.sql

3. How To Visualize Oracle Performance Data?

Fortunately Oracle SQL Develooper offers a very cool function that is called User Defined Reports on Reports label tab (you can find it by clicking Reorts on the View menu). Or taking a look at the three steps as below:

We can use the User Defined Reports to visualize oracle performance metrics mentioned previously in the section 2.

4. Using cool XML files to generate User Defined Reports of Oracle SQL Developer

You can directly download these XML files to your laptop and then choose Open Report by right-clicking the entry User Defined Reports in the Reports label tab of Oracle SQL Developer, next to choose a XML file that has already been saved to your computer, until you finished adding all of XML files using similar approach. Ultimately the oracle performance metrics have been shown on Reports label tab of Oracle SQL Developer, such as the following screenshot:

5. Relevant Blog Posts

On one hand I've also published a series of relevant blog posts on modb.pro, they're listed in chronological order as below:

• Visualizing the Oracle Perfornance Graph by Average Active Sessions - Chinese
• Visualizing the Oracle Performance Graph by Average Active Sessions & Logic CPUs - Chinese
• Visualizing the Oracle Performance Graph by Average Runnable Processes - Chinese
• Visualizing the Oracle Performance Graph by Active Sessions Per Activity Class - Chinese
• Visualizing the Oracle Performance Graph by Active Sessions Per Wait Class

On the other hand you're able to find the previous list as well from here.

6. License

This repository complies with the License of GNU General Public License v2.0, if you copy or forward it please consent all of the content of this protocol.