You are here |
mauro-pagano.com | ||
| | | |
carlos-sierra.net
|
|
| | | | SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In... | |
| | | |
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... | |
| | | |
carlos-sierra.net
|
|
| | | | OK, I will start with the basics... SQLTXPLAIN, also known as SQLT for short, is a tool I developed by myself and to myself. At least that was the idea when its name was coe_xplain.sql. That was long ago... like in the past millenia or so. Today, SQLT is a tool that Oracle uses to... | |
| | | |
thedailyspur.wordpress.com
|
|
| | Today's word is onion. Get the definition from dictionary.com or from the urban dictionary. If you use a WordPress, pingbacks should automatically track back to this page if you put in a link. If you use another blogging system, post your link in the comments so others can follow your work. Spam will be deleted. |