Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How do you keep track of querys using hints.

How do you keep track of querys using hints.

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 11 Oct 2004 12:28:39 -0400
Message-Id: <416AB4B7.000003.01696@DAZA-MGEJCA5J7T>


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
Received on Mon Oct 11 2004 - 11:24:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US