Oracle RDBMS - administration, tools,
scripts, and opinions...
Heres the paper Gene King and I presented at Oracle
OpenWorld 98 and IOUG-A Live! '99:
Here are some scripts that you might find useful. If i can
come up with some more I'll start a new page. These first five
come from the paper above.
- ana_all.sql - analyze all the
tables/indexes for a user. You might want to modify it
based on your non-uniformly distributed columns.
- compile_all.sql - compile
all the objects owned by a user.
- drop_all.sql - drop all of the
objects owned by a user. DANGEROUS!
- enacon.sql - enable all the
constraints in a schema (three times in case the
dependencies are not in alphabetical order.
- enacon_except.sql - one
pass at enabling constraints, with exceptions into the
Some useful Oracle-related sites: