|
You are here |
blog.yannickjaquier.com | ||
| | | | |
rwijk.blogspot.com
|
|
| | | | | ||
| | | | |
sqlmaria.com
|
|
| | | | | In a recent chat with Connor McDonald, we discussed if it is realistic to have applications that don't contain Optimizer hints. Ideally, the answer to this question is "yes", you don't need hints i... | |
| | | | |
oracleprof.blogspot.com
|
|
| | | | | 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... | |
| | | | |
dincosman.com
|
|
| | | 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.... | ||