Explore >> Select a destination
|
You are here 
|
mauro-pagano.com | ||
| | | | |
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:... | |
| | | | |
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] The blog post discusses various Oracle Database-related topics, including query optimization, performance issues, and script usage for documentation downloads. | |
| | | | |
tanelpoder.com
|
|
| | | Update: As this original article is from 2007, there are better options available in the modern times for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgans blog entry here. If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of views, which reference views, which reference more views etc. So there may ... | ||
