Re: sources for hidden and useful hints for testin

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 24 Jul 2004 00:27:18 +0100

There are quite a lot of hints which are undocumented -
of which a couple appear only on metalink, and some
in the recursive SQL used by the database.

I suspect some hints are undocumented because
they were simply overlooked when the manuals
were being written.  Some are clearly not supposed
to be available to end-users.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated July 20th




----- Original Message ----- 
From: "Justin Cave" <justin@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, July 24, 2004 12:02 AM
Subject: RE: sources for hidden and useful hints for testin


What hints are you talking about?  So far as I'm aware, all the valid SQL
hints are in the Optimizer Hints chapter of the Performance Tuning Guide
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref
.htm#8326


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: