You can use the following database tools to analyze performance bottlenecks:
● Database Analyzer
● XCONS
In SAP systems you can also use the CCMS.
See Database Administration in CCMS: MaxDB, Slow-Running Transactions