As a DBA I found one long running query (or) one query is using more temp space. I does not have much knowledge on tuning the query.
please guide me is there any oracle related internal utilities or views to provide the recomendations for that perticular query?
If possible please send the queries.
Thanks in advance.