/explore
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
tanelpoder.com
|
|
| | | | | As I promised in my previous post, I'm going to blog more frequently for a change. So here's a blog entry about some "new" Oracle execution plan displaying scripts that I've had since 2011 or so - I just tidied them up recently and added some improvements too. My aim in this blog post is not to go deep into SQL tuning topics, but just show what these scripts can do. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
sqlmaria.com
|
|
| | | | | Database views are a handy tool to help obfuscate complex joins from developers and analysts. However, knowing which view to use can be tricky, especially when faced with multiple views with simila... | |
| | | | |
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.... | ||
