Outer Web | Explore

Explore >> Select a destination

You are here		chandlerdba.com Hint Classifications - Neil Chandler's DB Blog
\|	\|	tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines????? \| Tony's Oracle Tips	9.3 parsecs away Travel
\|	\|	Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...	9.3 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com v$sql_hint \| Oracle Scratchpad	0.1 parsecs away Travel
\|	\|	Here's a quick and dirty script I thought I'd published a very long time ago. It has to be run as SYS and queries v$sql_hint to produce a list of all the things which (at least in theory) could be used as hints somewhere in the code. I've ordered the list by the columns version...	0.1 parsecs away Travel
\|	\|	www.xt-r.com XT&R blackboard: ?????? ? ???????? ????? ?????? ? Oracle 11.1 - 11.2.0.3(??????? ???????????????????)	2.3 parsecs away Travel
\|	\|	?????? ????? ???? ????? ?? 11.2.0.3 ? ?????? ??????(V$SQL_HINT), ????? ?????? ?? ???????? ? ???? ??????? ???????, ??????? ??????????? ??????...	2.3 parsecs away Travel
\|	\|	jhdba.wordpress.com Automatically running sql_advisor tasks from ADDM reports « Oracle DBA - A lifelong learning experience	26.9 parsecs away Travel
\|		STOP PRESS - 17 Nov 2009 - updated with latest code which works against both 10g and 11g databases I am attaching scripts which I wrote a while ago to automatically pick any sql_ids reported in the latest ADDMand then run sql_advisor toreport on any tuning advice. I am not suggesting that the information they...	26.9 parsecs away Travel