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		oracle-base.com GROUP BY ALL in Oracle Database 23ai/26ai - ORACLE-BASE
\|	\|	mahmoudhatem.wordpress.com Adaptive Dynamic Sampling : DYNAMIC_SAMPLING_RESULT & STALE_PERCENT \| Hatem Mahmoud's blog	2.2 parsecs away Travel
\|	\|	Since oracle 12.2.0.1 Adaptive Dynamic Sampling result are stored inside SPD as a special directive type "DYNAMIC_SAMPLING_RESULT". This will allow the result of ADS to be persisted on disk,thus it will survive memory flush and database restart.For more detailed info please check Mauro Pagano blog Post Something new about SQL Plan Directives and 12.2 We...	2.2 parsecs away Travel
\|	\|	oracleprof.blogspot.com Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines	2.4 parsecs away Travel
\|	\|	SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...	2.4 parsecs away Travel
\|	\|	leonotes.wordpress.com (transitive closure)?(Constraint-Generated Predicates) \| LEO Notes	2.4 parsecs away Travel
\|	\|	transitive closure?Wiki?Oracle?...	2.4 parsecs away Travel
\|	\|	blog.yannickjaquier.com Automatic SQL Tuning Sets (ASTS) hidden feature hands-on	16.5 parsecs away Travel
\|		Automatic SQL Tuning Sets (ASTS) can be of great help to auto repair SQL queries that have diverged from their ideal execution plan	16.5 parsecs away Travel