Outer Web | Explore

Explore >> Select a destination

You are here		tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines????? \| Tony's Oracle Tips
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	2.6 parsecs away Travel
\|	\|	Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...	2.6 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	2.5 parsecs away Travel
\|	\|	The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating...	2.5 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com use_nl hint \| Oracle Scratchpad	2.5 parsecs away Travel
\|	\|	In response to a recent lamentation from Richard Foote about the degree of ignorance regarding the clustering_factor of indexes I commented on the similar degree of ignorance regarding the syntax of a specific hint, namely use_nl(a b), pointing out that this does not mean "do a nested loop from a to b". My comment was...	2.5 parsecs away Travel
\|	\|	chandlerdba.com Fundamental Security Part Nine - Scripted Passwords - Neil Chandler's DB Blog	30.9 parsecs away Travel
\|		October 2024 - Oracle 19C, 23ai Photo by Julius Drost on Unsplash So a while ago I spoke about passwords but forgot to mention a key element of account control in the blog. I was giving a talk on Security a few days ago and told an audience member that this information was in my...	30.9 parsecs away Travel