Top resource consuming query

Database
Enthusiast

Top resource consuming query

Hi,

I have to get the top resource hungry queries...? If any one help with the queries which can give me top 10 distinct queries it will be very help full. I have onle select access on pdcrinfo views. It is on TD 14.10. Please help.

1 REPLY
Enthusiast

Re: Top resource consuming query

Hi

pdcr reports have a top x report you can run to show the highest cpu resourced queries.

Cheers

Steven