I'm not as familiar with Oracle, but I do worry about having too much stuff dropped into tempdb. I'd rather have some sort of redo area per database to handle changed rows.

I also think that transactions are one of those areas that are hard for people to learn what a good practice is.