21 March 2007
PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance. GPL
OraRep 0.3.7 is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.
Subscribe to:
Post Comments (Atom)
1 comment:
I have a little writeup on running SqlPlus commands and PL/SQL procedures from a shell script. Take a look at it. Its located at http://timarcher.com/?q=node/48
It demonstrates a simple way to do it under Oracle and RedHat Linux. Furthermore I show you how to get the return codes from the sql plus execution into your unix script so that you can jump to an appropriate path of execution in your shell script.
Post a Comment