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		jonathanlewis.wordpress.com Plans in Memory \| Oracle Scratchpad
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	1.7 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...	1.7 parsecs away Travel
\|	\|	tanelpoder.com Where does the Exadata storage() predicate come from? \| Tanel Poder Consulting	1.9 parsecs away Travel
\|	\|	On Exadata (or when setting cell_offload_plan_display = always on non-Exadata) you may see the storage() predicate in addition to the usual access() and filter() predicates in an execution plan: SQL> SELECT * FROM dual WHERE dummy = 'X'; D - X Check the plan: SQL> @x Display execution plan for last statement for this session from library cache... PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------ SQL_ID dtjs9v7q7zj1g, child number 0 ------------------------------------- SELECT * FROM dual WHERE dummy = 'X' Plan hash value: 272002086 ------------------------------------------------------------------------ \| Id \| Operation \| Name \| E-Rows \|E-Bytes\| Cost (%CPU)\| ------------...	1.9 parsecs away Travel
\|	\|	oracle-base.com ORACLE-BASE - Oracle SQL Articles	2.6 parsecs away Travel
\|	\|	ORACLE-BASE - Oracle SQL Articles	2.6 parsecs away Travel
\|	\|	www.adamconrad.dev Data models and query languages - Adam C. Conrad	54.1 parsecs away Travel
\|		Ch 2 of my book club review of Designing Data-Intensive Applications by Martin Kleppmann.	54.1 parsecs away Travel