Database 8.1.7.4 Optimizer = Choose
Application written for Rule but use of lot of Hints in code.
Reason of using cost based optimizer to create/use function based indexes.
Selected tables are analyzed as all tablles(except sys) resulted in bad performance.
This is the environment of a short time project I am working with. I would like to track all those tables which are being used in application/customized code using HINTS and atleast analyze those tables
which are not in their selective analyze list which is also not being analyzed regularly.
What is the best place to check such codes v$sqlarea/V$sql/V$sqltext or any other place in database.
I will appreciate a sql code to fetch all such codes from database.
If I am thinking in wrong direction, I shall appreciate your assistance.Right now I don't have option to check application codes from system.
Regards Rafiq
_________________________________________________________________
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).