Explore >> Select a destination
|
You are here 
|
antognini.ch | ||
| | | | |
dioncho.wordpress.com
|
|
| | | | | One of the customers complained that Oracle refuses to use the HASH GROUP BY operation under any circumstances. It's 10gR2(10.2.0.1) database. See that Oracle simply refuses to use HASH GROUP BY operation even with the simplest group by? You might think that the "_gby_hash_aggregation_enabled" would have been false which is clearly right. But even with... | |
| | | | |
nenadnoveljic.com
|
|
| | | | | New optimization causing severe performance degradation. It can be switched off with the fix control. | |
| | | | |
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.... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | I've uploaded a monitoring script that I have worked on: zip. The script alerts you when the optimizer runs a SQL statement with a potentially new and inefficient plan so you can intervene. ... | ||
