Author: SSWUG Research

Community

Redundant Index Report

by Andrew Allen – Yeah, yeah, yeah. Nobody likes ’em but we all got ’em (redundant indexes, that is). So here is an easy way to find redundant indexes. This script will list all redundant indexes in a database by owner, table (up to a max of 16 columns).

Community

Notify Oracle application users

By Shankar Govindan – Here is a script that spools the Mail ID’s of the Application users and mails them whatever you want to notified them. This only requires that when a user is created, the Mail ID information is fed in and exists in the AOL tables of the database. The script was tested on 10.7 N