Explore >> Select a destination
|
You are here 
|
kerryosborne.oracle-guy.com | ||
| | | | |
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. | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Jump to summary. A new optimizer feature that appears in 23c (probably not 21c) was the ability to push group by clauses into union all set operations. This will happen unhinted, but can be hinted with the highly memorable [no_]push_gby_into_union_all() hint that appeared in 23.1.0.0 according to v$sql_hint. and the feature can be disabled by... | |
| | | | |
blog.tanelpoder.com
|
|
| | | | | Despite the title, this is actually a technical postabout Oracle, disk I/O and Exadata & Oracle In-Memory Database Optionperformance. Read on :) If a car dealertells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically differentfrom all the old ones. You don't just get orders of magnitude performance improvements by making small changes. Perhaps the car bends space around... | |
| | | | |
antognini.ch
|
|
| | | |||
