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
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	1.0 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...	1.0 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	3.3 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...	3.3 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	1.1 parsecs away Travel
\|	\|	The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating...	1.1 parsecs away Travel
\|	\|	blog.oracle-ninja.com Checking Flash Cache Mode in Exadata Cloud - Andy Colvin's Oracle Blog	26.0 parsecs away Travel
\|		While looking at an exachk report for an Exadata rack running in Oracle Cloud Infrastructure, I saw an interesting finding: Since this is an Oracle cloud environment, we don't have any access...	26.0 parsecs away Travel