Explore >> Select a destination
|
You are here 
|
afatkulin.blogspot.com | ||
| | | | |
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.... | |
| | | | |
sqlmaria.com
|
|
| | | | | Although there have been a number of significant changes to the Oracle Database in 12c, some of my favorite new features are actually the small enhancements, designed to make your life a little eas... | |
| | | | |
dioncho.wordpress.com
|
|
| | | | | I hit following OTN forum article which was a discussion on typical SQL sharing problem. There are so many reasons why Oracle does not share the same statement. Oracle records the reason in v$sql_shared_cursor view. In my local 10.2.0.1 database, v$sql_shared_cursor has 53 reasons of unshareability. But I have a big complaint on v$sql_shared_cursor view.... | |
| | | | |
www.longdelayspossible.com
|
|
| | | Wings of desire... | ||
