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		savvinov.com DBMS_XPLAN.DISPLAY_CURSOR - Oracle Diagnostician
\|	\|	jonathanlewis.wordpress.com dbms_xplan in 10g \| Oracle Scratchpad	2.0 parsecs away Travel
\|	\|	[More on dbms_xplan.display_cursor()] If you're using 9i and haven't learned about the dbms_xplan package, then you should take a good look atit right away. It's(usually) a much better wayof getting execution plans from your system thanwriting yourown queries against the plan_table. If you'vebeen using dbms_xplan, and upgraded from 9i to 10g, make sure that you...	2.0 parsecs away Travel
\|	\|	iusoltsev.wordpress.com FIRST_ROWS CURSOR_SHARING_EXACT \| Oracle mechanics	1.8 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.8 parsecs away Travel
\|	\|	tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines? \| Tony's Oracle Tips	3.1 parsecs away Travel
\|	\|	Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...	3.1 parsecs away Travel
\|	\|	roape.net Debates - ROAPE	19.8 parsecs away Travel
\|		[AI summary] The content is a cookie consent notice and introductory information about the Review of African Political Economy (ROAPE) journal, including subscription details.	19.8 parsecs away Travel