
Carlos Sierra's Tools and Tips
425 FOLLOWERS
Follow this blog for Tools and Tips for Oracle Performance and SQL Tuning.
Carlos Sierra's Tools and Tips
1y ago
If you have access to some other graphical tool that displays time series on multiple dimensions for one or a set of SQL statements from an Oracle database, then you may not need “SQL Stats Analytics”. In the other hand, if you have no such tool, or even more restricting, if you can only access your Oracle database through some client connection such as SQL*Plus, then you may have some use for the open-source “SQL Stats Analytics” presented here.
Before you go on, a fair warning: this open-source tool reads DBA_HIST_SQLSTAT, therefore it assumes you are licensed to use the Oracle Diagnostics P ..read more
Carlos Sierra's Tools and Tips
1y ago
Carlos Sierra's Tools and Tips
3y ago
Available on https://github.com/carlos-sierra/cscripts/blob/master/README.md ..read more
Carlos Sierra's Tools and Tips
4y ago
I used to like (Average Active Session History) ASH Analytics available trough Oracle Enterprise Manager (OEM). Then OEM was not always available, or the time to reach it was too long, or its access too cumbersome at best. Slowly for surely, I started using (and developing) stand-alone scripts to get what I needed from ASH in a timely manner.
Many Developers and even DBAs have access to an Oracle database through SQL*Plus, but not to OEM or any other GUI to check on database performance. And in many cases, access is only available through a client machine (i.e. your Mac or PC), but never to th ..read more