Explore >> Select a destination
|
You are here 
|
antognini.ch | ||
| | | | |
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.... | |
| | | | |
chandlerdba.com
|
|
| | | | | Photo by Brian Patrick Tagalog on Unsplash July 2024. Oracle 19c, 23ai There are 3 main types of SQL Plan Management: SQL Profile SQL Plan Baseline SQL Patch So first some quick background info about the 3 options and then I'll tell you about my mistake. SQL Profile A SQL Profile is a collections of... | |
| | | | |
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... | |
| | | | |
power2build.wordpress.com
|
|
| | | Another tool to help with SQL Tuning? Yes! Hopefully with some advantage over what you used until today :-) Collecting diagnostics around a SQL is not fun, if you've been there you know that.... Source: SQLd360, SQL diagnostics collection made faster | ||
