Profileimage by Alexey Awrovich Building Oracle database performance graphs using AWR data from

Alexey Awrovich

partly available

Last update: 28.10.2023

Building Oracle database performance graphs using AWR data

Graduation: Oracle OCP
Hourly-/Daily rates: show
Languages: English (Native or Bilingual) | Russian (Native or Bilingual)

Keywords

HTML Oracle Databases SQL Databases Databases JavaScript (Programming Language) Relational Databases Web Servers SQL*Plus Time Series Metrics

Attachments

2Example-Sessions_281023.png
2Example-TopSQL_281023.png
2Example-CPU_281023.PNG
2Example-HOST_281023.png

Skills

I can build ~100+ graphs about load and performance of your Oracle database using awrextr.sql awr data.
 
Send me a link to your awr extracted dump, and after 24-48 hours I will send you a link to password protected zip file with html reports with graphs.
 
Report example you can download here:
 
Price:
1000$ per Prod Database 1 report *
    50$ per Test/Dev DB 1 report *
 
*awr dump file size limit 15gb, if awr dump file size for example will contain 1 year of data with 150gb of awr extracted data, cost will increase (~ +1000$ per extra 15gb). Building of all reports on 15gb awr data will take in common 24h.
 
Report will contain:
 
  • Html files with 100+ graphs
  • Graphs is interactive and zoomable
  • Table of contents with search
  • Cpu usage time series graph
  • IOPS, transactions, logons per second and more
  • Top 10 sqls
  • Trends for wait classes
  • Trend of metrics in db
  • Top 5 sql elapsed time changes
  • Top 30 sql by elapsed time, plans, sql text, graphs
  • Db and instance restart times
  • Top modules, services
  • Table of top blockers by events (like enq: TX - index contention, enq: TX - index contention)
 
Report can be shown to your boss, pages of this report can be used for your own reports.
 
**
Currently supported Oracle database versions: 11,12,19 only Enterprise Editions.
 
***
Rac database separate instance info shown only first 2 instances. All instance cumulative instances still available
****
Pdbs not tested yet
*****
All this developed and will be processed by one person, and deadlines may be shifted if I am on vacation or not at the computer on weekends.
 
 
 
How to exatract AWR dump with awrextr.sql:
 
Sqlplus sys/password@yourdb as sysdba
 
Create or replace directory awr_extr as '/u01/tmp';
 
@?/rdbms/admin/awrextr
 
**** zip html files requrements. Html files contains js script, and for graphs view you need:
 
1. Put it to your webserver
or
2. Open it by Chrome in unsecure mode like this (js open local *.csv files data):
"C:\Program Files\Google\Chrome\Application\chrome.exe --disable-web-security --user-data-dir="C:\tmpChromeSession 
or
3. I can put it on my hosting with login/password

Project history

11/2021 - 11/2023
Oracle DBA consultant
(Internet and Information Technology, 1000-5000 employees)

Building graphs on Oracle Database AWR data

Certifications

Oracle 12 OCP
Oracle
2018

Local Availability

Only available for remote work
Profileimage by Alexey Awrovich Building Oracle database performance graphs using AWR data from Building Oracle database performance graphs using AWR data
Register