Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
Attached is the latest version of the gather info file with a few changes to some existing queries and a few new queries based on some things now available in Oracle 11g. The article which discuesses interpretration of the output can be found here (authenticated).