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 Troubleshooting stuck queries - Oracle Diagnostician
\|	\|	kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.	2.4 parsecs Travel
\|	\|
\|	\|	rwijk.blogspot.com About Oracle: dbms_xplan.display_cursor	2.3 parsecs Travel
\|	\|
\|	\|	nenadnoveljic.com Performance Problem with Incremental Statistics Calculation - All-round Database Topics A frequently executed SQL causes problems with the initial incremental statistics calculation.	2.2 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....	3.9 parsecs Travel
\|