Outer Web | Explore

Explore >> Select a destination

You are here		sqlmaria.com Better diagnostics for SQL regressions in 19c and beyond #JoelKallmanDay
\|	\|	dioncho.wordpress.com Interesting case of the restriction of global hints \| Dion Cho - Oracle Performance Storyteller	3.0 parsecs away Travel
\|	\|	One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the...	3.0 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com Push Group by \| Oracle Scratchpad	3.2 parsecs away Travel
\|	\|	Jump to summary. A new optimizer feature that appears in 23c (probably not 21c) was the ability to push group by clauses into union all set operations. This will happen unhinted, but can be hinted with the highly memorable [no_]push_gby_into_union_all() hint that appeared in 23.1.0.0 according to v$sql_hint. and the feature can be disabled by...	3.2 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	3.6 parsecs away Travel
\|	\|	When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE\|LIST\|HASH] ITERATOR or PX PARTITION [RANGE\|LIST\|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...	3.6 parsecs away Travel
\|	\|	afatkulin.blogspot.com Alex Fatkulin's Blog: v$result_cache_memory or what is the newest method to hang stuff up?	13.5 parsecs away Travel
\|		Sometimes I get quite amused by the "side effects" you can discover while playing with features. Prerequisites First, we need to place somet...	13.5 parsecs away Travel