Find those Resource Consumers using Heat Maps
Okay the jargon apart, will try to explain what we're doing in the simplest form. There is something called 'Archive Logs' as the name suggests, these are the archives, keeping track of the changes occurring to the Oracle Databases. Depending on the configuration and the activity being done on the database, the number of archives generated can increase significantly. Lets not dwell into the technical details of the Oracle Database Architecture. Our primary goal is to show how a simple Heat Map can be used to visualize the intensity of the operations, in our case the number of archives generated. The higher the number, the redder the color of the map.
Steps we performed:
- Read the Archive Log information from the excel sheet. (or connect to the Databse and get the data, whichever you like)
- How did we get the data into excel sheet? Run the appropriate command in Oracle DB and spool the data into the excel sheet.
- Perform Feature Creation by adding two new columns Date and Time because working with the HOUR column directly is cumbersome.
- Remove the HOUR column
- Create out favorite PIVOT_TABLE using the selected columns, i have fallen in love with this. It makes our lives easier.
- Fill in the null values with the float number 0.0 to indicate NO ARCHIVES WERE GENERATED at that specific time interval.
- Plot the graph using plotly library.
Comments
Post a Comment
Hey there, feel free to leave a comment.