A pair of Oracle audit scripts
These have been generously donated to the Oracle community by Brian Mullin.
The zip file contains scripts for both 9i and 10g which provide a lot of information about what resources, features and many other things that the the database is using.