/explore
|
You are here 
|
mauro-pagano.com | ||
| | | | |
carlos-sierra.net
|
|
| | | | | SQLTXPLAIN includes into the sqlt/utl sub-directory a script named coe_xfr_sql_profile.sql. This script inputs a SQL_ID, then it asks to choose from a list of known Plan Hash Values (PHV), and after a few seconds it outputs another script that contains the Outline of the PHV together with the SQL Text for the given SQL_ID. These... | |
| | | | |
antognini.ch
|
|
| | | | | [AI summary] A collection of technical blog posts discussing Oracle Database performance tuning, troubleshooting, query optimizer features, and script updates for various database versions. | |
| | | | |
iggyfernandez.wordpress.com
|
|
| | | | | Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:... | |
| | | | |
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.... | ||
