|
You are here |
jonathanlewis.wordpress.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.... | |
| | | | |
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. ... | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
leonotes.wordpress.com
|
|
| | | ????????transitive closure?Wiki??????????Oracle????????... | ||