Req# Predict that the sql text running in the system will consume high resources.
I wanted to predict this based on the temp space and undo table space used by the query.
I am thinking to use Clustering algo.
Can anyone suggest me, which algo should I use.
Yes there will be multiple queries. I wanted to classify bad sql ( bad sql meaning, sql which are going to consume more than 80% temp or consuming high io)