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		carlos-sierra.net SQLTXPLAIN 101 \| Carlos Sierra's Tools and Tips
\|	\|	www.bobbydurrettdba.com Using coe_xfr_sql_profile.sql to force a good plan \| Bobby Durrett's DBA Blog	1.8 parsecs away Travel
\|	\|	Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe...	1.8 parsecs away Travel
\|	\|	easyoradba.com ORA-24247: Network Access Denied by Access Control List (ACL) on Oracle Database 23ai - EasyOraDBA	2.9 parsecs away Travel
\|	\|	This error occurs if you're trying to access a URL on Oracle23ai from within the database and don't have the...	2.9 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	2.0 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...	2.0 parsecs away Travel
\|	\|	afatkulin.blogspot.com Alex Fatkulin's Blog: Update and rownum oddity	9.2 parsecs away Travel
\|		Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod...	9.2 parsecs away Travel