Outer Web | Explore

Explore >> Select a destination

You are here		kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
\|	\|	dbtimewizard.com.br SQL Profile: Como sobreviver sem ela? \| DBTimeWizard	11.4 parsecs away Travel
\|	\|	Como alterar plano de execução sem alterar o código da aplicação utilizando o recurso "SQL PLAN MANAGEMENT".	11.4 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	10.9 parsecs away Travel
\|	\|	??????? ?????? ?? ??????? ??????????? 465 ??????! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%????????%' OR A.LASTNAME LIKE '%????????%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ??? ???????, ????????? ???? ?? ??????? A.COMPANY_ID = 1 ???????? ??????? ???????????????? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT...	10.9 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	9.8 parsecs away Travel
\|	\|	Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...	9.8 parsecs away Travel
\|	\|	nenadnoveljic.com Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics	46.3 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.	46.3 parsecs away Travel