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		blog.yannickjaquier.com Automatic SQL Tuning Sets (ASTS) hidden feature hands-on
\|	\|	optimizermagic.blogspot.com Inside the Oracle Optimizer - Removing the black magic: Displaying and reading the execution plans for a SQL statement Generating and displaying the execution plan of a SQL statement is a common task for most DBAs, SQL developers, and preformance experts as i...	1.7 parsecs Travel
\|	\|
\|	\|	rwijk.blogspot.com About Oracle: dbms_xplan.display_cursor	1.5 parsecs Travel
\|	\|
\|	\|	blog.toadworld.com Why my execution plan has not been shared - Part I Why my execution plan has not been shared - Part I	1.8 parsecs Travel
\|	\|
\|	\|	dincosman.com Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog 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....	10.2 parsecs Travel
\|