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		sqlmaria.com Optimizer Histograms
\|	\|	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.3 parsecs Travel
\|	\|
\|	\|	rwijk.blogspot.com About Oracle: dbms_xplan.display_cursor	2.3 parsecs Travel
\|	\|
\|	\|	oracleprof.blogspot.com Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...	2.3 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....	12.0 parsecs Travel
\|