when assigned to a custom side, what 's the check list for bad performance?

can somebody provide such kind of list?

such as
1. bad query
2. rollback segment.
3. cpu boundary.
4.....


any thing else?