I have written a simple Unix shell script driven menu which contains SQL scripts which covers most common day to day DBA activity tasks related to monitoring and performance tuning. Once installed in a central location, we canconnect to any database in our enterprise and monitor it from one interface.
We can also connect to and monitor any databases on Windows platform. The scripts will support all databases in versions 10g as well as 11g – a few menu options may not work for Oracle 9i databases.
Have a look at the screen shots below. The download links as well as installation instructions are provide below as well.
Please let me know if this menu can be enhanced in any way and your feedback will be taken on board.
For eg – export PATH=.:$PATH
Note – please download for the appropriate Operating System
a) For AIX and Solaris :
b) For Linux: