Outer Web | Explore

Explore >> Select a destination

You are here		alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog
\|	\|	www.bobbydurrettdba.com Using coe_xfr_sql_profile.sql to force a good plan \| Bobby Durrett's DBA Blog	2.5 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...	2.5 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com SQL Profiles - 2 \| Oracle Scratchpad	2.2 parsecs away Travel
\|	\|	Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few...	2.2 parsecs away Travel
\|	\|	carlos-sierra.net SQLTXPLAIN 101 \| Carlos Sierra's Tools and Tips	2.1 parsecs away Travel
\|	\|	SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In...	2.1 parsecs away Travel
\|	\|	akorotkov.github.io Thoughts About Jsonb Statistics - Alexander Korotkov's blog	48.4 parsecs away Travel
\|		[AI summary] The article discusses the challenges and potential solutions for improving selectivity estimation in PostgreSQL's jsonb data type, focusing on statistics collection for efficient query planning.	48.4 parsecs away Travel