Scripts

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:

SQL> @http://www.miraclebenelux.nl/scripts/….

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: