Explore >> Select a destination


You are here

antognini.ch
| | dincosman.com
1.9 parsecs away

Travel
| | 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
2.5 parsecs away

Travel
| | 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
3.3 parsecs away

Travel
| | 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
19.0 parsecs away

Travel
| 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