I know this can probably be done through OEM but a lot of my the clients I support dont know how to use nor and some dont have access.
Therefore, I would like to some help on putting together to find the 20 worse performing SQL's.
By worse, I mean longest running.
I am thinking the report should have have the following columns
SQL ID, hash value start date, start time, end date, end time and the full SQL text of the query.
Anything else that may be pertinent to help debug the issue. If the output can be generated in HTML format
for ease of reading that would be excellent.
Thanks in advance to all who answer. If the output can be posted so I can review that would be great.