Here you can find some of the scripts that I use. You should be able to execute directly from SQL*Plus with the following command:
Have fun ….
Script 1: Show the Average I/O per directory or mount for example: perid.sql
This script will sum up the number of READS and WRITES (IO operations) per ID. The ID is coming from the filename and can be for example the mount point or the directory. This can help in determining if the I/O is evenly distributed across the mountpoints.
Script 2: Show indexes and index columns for a given table for a user: usridx.sql
Script 3: Show indexes and index columns for a given table for the whole database: dbaidx.sql