Explore >> Select a destination
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few... | |
| | | | |
blog.yannickjaquier.com
|
|
| | | | | SQL Plan Management feature overview through concrete example and its interactions with Adaptive Cursor Sharing (ACS) and SQL Profile | |
| | | | |
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.... | |
| | | | |
iggyfernandez.wordpress.com
|
|
| | | Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:... | ||
