Monitoring Logswitches

From: Roman Klesel <rupa_at_firemail.de>
Date: Fri, 9 Jul 2004 13:21:50 +0000 (UTC)
Message-ID: <slrncet6vf.134.rupa@gemini.office.noris.de>

Dear DBAs,

with the help of this newsgroup I was usually able to solve my DB problems. Thanks for the help.

Now I would like to contribute something.

I wrote a little script to monitor logswitches. It displays the logswitches in a matrix similar to what TOAD does.

You can get it from http://www.lotuseyes.de/oracle/logswitches.gz

Additionally it is RAC aware. This means it displays the logswiches instance specific, which the version of TOAD that I have seen does not.

As it is it uses the "connect / as sysdba" mechanism so you will want to run it on the DB server.

However it can easyly be modified to connect any other way you like.

I'm using it on Solaris 9 with Oracle 9 but basically it should run on every UNIX like environment. For Oracle 8 replace "first_time" with "time" in the script.

Basicaly it requires /bin/bash and nawk in the path. And of cause the ability to connect with sqlplus "/ as sysdba" from where you run it.

Please feel free to check it out. I would be gald to get some feedback.

Roman Received on Fri Jul 09 2004 - 08:21:50 CDT