Outer Web | Explore

Explore >> Select a destination

You are here		savvinov.com SQL tuning: real-life example - Oracle Diagnostician
\|	\|	dincosman.com Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog	2.5 parsecs away Travel
\|	\|	The performance issue with an SQL query was resolved by using the /+ PARALLEL(2) / hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....	2.5 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	3.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...	3.0 parsecs away Travel
\|	\|	rwijk.blogspot.com About Oracle: Performance aspects of APEX reports	2.8 parsecs away Travel
\|	\|		2.8 parsecs away Travel
\|	\|	afatkulin.blogspot.com Alex Fatkulin's Blog: Update and rownum oddity	7.5 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...	7.5 parsecs away Travel