Explore >> Select a destination
|
You are here 
|
www.pythian.com | ||
| | | | |
oracle-randolf.blogspot.com
|
|
| | | | | Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT A... | |
| | | | |
antognini.ch
|
|
| | | | | [AI summary] This article details new SQL features in Oracle 12c and 18c that enhance partition-wise operations for GROUP BY, DISTINCT, and windowing functions to improve parallel query performance. | |
| | | | |
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.... | |
| | | | |
hourim.wordpress.com
|
|
| | | I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without... | ||
