Outer Web | Explore

Explore >> Select a destination

You are here		sqlmaria.com How to use DBMS_STATS DIFF_TABLE_STATS functions
\|	\|	nenadnoveljic.com Performance Problem with Incremental Statistics Calculation - All-round Database Topics	10.1 parsecs away Travel
\|	\|	A frequently executed SQL causes problems with the initial incremental statistics calculation.	10.1 parsecs away Travel
\|	\|	alexzeng.wordpress.com # Expert Oracle Practices # PL/SQL and the CBO \| Alex Zeng's Blog	10.0 parsecs away Travel
\|	\|	I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I'd like to summary and share what I learned. This chapter PL/SQL and the CBO by Jo?e Senega?nik is pretty interesting. It tells how to use oracle extensible optimizer to set the selectivity and the cost of PL/SQL functions. This will...	10.0 parsecs away Travel
\|	\|	mikedietrichde.com Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt	10.4 parsecs away Travel
\|	\|	Come and meet us at our Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt - Upgrade / Migration / Patching	10.4 parsecs away Travel
\|	\|	nenadnoveljic.com Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics	67.0 parsecs away Travel
\|		Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD.	67.0 parsecs away Travel