SQL Stats Analytics (from SQL*Plus!)
Carlos Sierra's Tools and Tips
by Carlos Sierra
8M 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
Visit website
CS Scripts Tool Kit 2023-07-29 is now available!
Carlos Sierra's Tools and Tips
by Carlos Sierra
8M ago
..read more
Visit website
Toolkit cscripts v202111 is now available
Carlos Sierra's Tools and Tips
by Carlos Sierra
2y ago
Available on https://github.com/carlos-sierra/cscripts/blob/master/README.md ..read more
Visit website
ASH Analytics from SQL*Plus
Carlos Sierra's Tools and Tips
by Carlos Sierra
3y 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
Visit website

Follow Carlos Sierra's Tools and Tips on FeedSpot

Continue with Google
Continue with Apple
OR