SOA Suite applications make heavy use of the database. Identifying the database queries that are running slowly can allow you to identify areas where performance improvements can be made by tuning or reducing the amount of database access.
You will need SOA Suite installed and running, and have loaded it with representative load or live data.
This recipe requires that you are able to log in to the SOA Suite database as an administrator and are able to execute the necessary SQL statements.
SELECT * FROM (SELECT sql_fulltext, sql_id, child_number, disk_reads, executions, first_load_time, last_load_time FROM ...