Notes on Oracle’s solution to find object dependencies, DEPTREE. Written in 1991, and still included on installation.
Oracle DBA Script To List Objects That Won’t Extend Due to lack of space.
A useful script to show how full the tablespaces are. I’ve used it many times!
I did some initial schema analysis on Oracle Apps R12 sample database, VIS.
VIS uses hardly any primary keys, many non unique indexes, and a LOT of package and triggers.
Lots of potential for data integrity and tuning issues.