This is a very simple script to extract some helpful information from the awr reports generated from a SLOB run.
PREPARATION:
First, rename it to awr_info.sh and chmod it for execute permission:
$ mv awr_info.sh_.txt awr_info.sh
$ md5 awr_info.sh
MD5 (awr_info.sh) = 48c39d920a2c128899cff74901ceae1b
$
$ chmod +x awr_info.sh
USAGE:
By convention you should rename awr.txt after a run of runit.sh. It is best to rename to some arbitrary name that makes sense to you but have 2 dot-seperated suffixes to track the number of writer and reader sessions. For example:
$ sh ./runit.sh 0 32
$ mv awr.txt awr.txt.0.32
This is the February 1, 2013 drop of the SLOB tar archive. After downloading it, please compute an md5sum on it. For example, using OSX md5 command you will see the following type of output. The md5 checksum will, of course, be the same whether computed by Linux md5sum or any other such command.
The changes in this tarball are to the cr_db.sql script which had a faulty alter tablespace command in it. I've also added a very crude yet helpful awr post-processing script called awr_info.sh under the misc directory. See the README in that directory for more info on the script.
$
$ ls -l 2013.02.01-slob-kit.tar_.gz
-rw-r--r--@ 1 clossk staff 10040 Feb 1 16:16 2013.02.01-slob-kit.tar_.gz
$ md5 2013.02.01-slob-kit.tar_.gz
MD5 (2013.02.01-slob-kit.tar_.gz) = f157b1c51b553f90df53fcea95f89632
$
Recent comments
17 weeks 9 hours ago
26 weeks 5 days ago
28 weeks 3 days ago
31 weeks 5 days ago
33 weeks 6 days ago
43 weeks 3 days ago
45 weeks 11 hours ago
46 weeks 12 hours ago
46 weeks 1 day ago
48 weeks 6 days ago