Outer Web | Explore

Explore >> Select a destination

You are here		mauro-pagano.com SQLTXPLAIN vs SQLd360, differences and similarities \| Mauro Pagano's Blog
\|	\|	www.bobbydurrettdba.com Using coe_xfr_sql_profile.sql to force a good plan \| Bobby Durrett's DBA Blog	10.1 parsecs away Travel
\|	\|	Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe...	10.1 parsecs away Travel
\|	\|	power2build.wordpress.com SQLd360, SQL diagnostics collection made faster « Power to Build	9.2 parsecs away Travel
\|	\|	Another tool to help with SQL Tuning? Yes! Hopefully with some advantage over what you used until today :-) Collecting diagnostics around a SQL is not fun, if you've been there you know that.... Source: SQLd360, SQL diagnostics collection made faster	9.2 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	12.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...	12.6 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	35.2 parsecs away Travel
\|		????????transitive closure?Wiki??????????Oracle????????...	35.2 parsecs away Travel