Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		carlos-sierra.net Custom SQL Profile and Plan Stability on 10g \| Carlos Sierra's Tools and Tips
\|	\|	oracletoday.blogspot.com Oracle Today: Modifying sprepins.sql for Custom Statspack Reports I	16.7 parsecs away Travel
\|	\|	I use STATSPACK extensively for comparing two time periods, comparing a time period to a baseline, monitoring trends and diagnosing perform...	16.7 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	7.7 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...	7.7 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	8.0 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...	8.0 parsecs away Travel
\|	\|	rwijk.blogspot.com About Oracle: Filter predicates with NVL on mandatory columns using the index	18.5 parsecs away Travel
\|			18.5 parsecs away Travel