Re: How do you keep track of querys using hints.

you shouldn't need 1,000 queries with hints unless your tables are not analyzed. I have found that if my tables are analyzed and even if I'm not using system stats and have really bad index paramters I only have to hint 1% or less of all queries. How I keep track of them depends on the processes at the job site. I like to keep a copy of them in a file so i can run them at will.

We are going to start implementing a process for 'tagging' our queries so we can identify where they are stored and what part of the application they are for. This is something that may help:

select /*+ hinted <your hint> */

this way you can search v$sqlarea for the keyword 'hinted'. We are using hints to tell us the module and the file(we are storing sql in xml files) we are storing the query in. This way if a query comes back with a performance problem we know what group to call and where to find the query. -------------- Original message --------------

> Hi, one question please , I had seen is necesarry to set hints to improve
> performance of specific queries, but
> the load of the data can change and the hints can become harmful.
>
> I don't know how can one keep track of more than 1,000 queries with hints.
>
> When you set hints in some queries how do you keep track of them,
> you apply hints only through views?
> you periodically check?
> you don't use hints except a very very few situations?
> etc.
>
> Thank you
>
> Juan Carlos Reyes Pacheco
> OCP
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l