disk
vsysstat_ioworkload.sql
Calculate the IOPS for small and large I/O, the percentage of reads to writes, and the MBPS throughput over a period of time as seen by the database. This is important for matching up expected I/O rates on the disk subsystem and what is actually seen in the database.

---

wrh_sysstat_ioworkload.sql
As a followup to vsysstat_ioworkload.sql, here is a script that does the same thing against performance snapthots (workload repository history)

---

wrh_sysstat_ioworkload_ALL.sql

This is what it is all About!
Get complete history of IOPS & MBPS from workload repository history and graph it for you management. This allows you to see total database disk activity. Compare this against what your disk capacity is.
Just remember these numbers are for ALL disks. You can get average IOPS/MBPS by dividing by your total number of disks used in servicing database requests. Great information!

---

vsysstat_ioworkload.sh

vsysstat_ioworkload.sql

These two scripts give a report output much like iostat or vmstat.

Get IOPS & MBPS plus read/write percentages from an Oracle database on a predefined interval.

---

vfilestat_iopercent_mount.sql
Use this script along with the workload scripts to match (IOPS/MBPS) with read/write percentages. Doing this gives a good indication if your disk subsystem is balanced.

---

vtempstat_iopercent_mount.sql
If you have your temporary files spread across multiple mount points it is often nice to see the distribution of these. It is also good to know if these temporary files are on data disks.

---

vfilestat_vtempstat_iopercent_mount.sql
If you have your temporary files on the same disks as your permanent data files, it is good to know the impact from a read/write percentage.

---

wrh_vfilestat_iopercent_mount.sql
Take a look at read/write percentages that is stored in the workload repository history tables (snapshots).

---

.BAT script
randid.BAT
Generate a random number.

---