I'd been away from Oracle for about three years, but am now back into it (and very happy as a result).

I've found my "Oracle 8i the complete reference" to still be invaluable - when it doubt it usually just takes a few seconds Googling to found out if info provided by the 8i book is still relevant for 9i. And since the project in which I'm involved doesn't contain much rocket science, the 8i information is pretty much always spot-on.

I still haven't tried the TOra tool yet, but we get by on a mixture of Oracle Enterprise Manager and TOAD.

Edit: Subject line.