|
You are here |
carlos-sierra.net | ||
| | | | |
hourim.wordpress.com
|
|
| | | | | I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without... | |
| | | | |
blog.tanelpoder.com
|
|
| | | | | Some years ago I wrote about how sqlplus allows you to run sqlplus scripts directly from HTTP and FTP locations instead of the local filesystem. By the way, I didn't even notice - my blog is over 5 years old already! :) I a recent email thread Marco Gralike just showed the simplest way I to open a HTTP URL and download + list its contents in a CLOB datatype. It's the HTTPURITYPE and its getCLOB (and getBLOB) methods. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
connor-mcdonald.com
|
|
| | | | | When I'm troubleshooting, a common workflow for me isextract a problematic SQL statement from V$SQL or V$SQLSTATS or an AWR report.drop the SQL text into SQL Developer or VS Code so that I can format it into a more readable format.That was starting to frustrate me so I thought: "Why not have a SQL Formatter... | |
| | | | |
timharford.com
|
|
| | | The children of North End, Boston, play in the shadow of an enormous steel tank of molasses. The thick, sticky sugar syrup is being used to make munitions for the First World War. When a worker notices dark molasses seeping from the tank, hewarns thecompany that there could be a leak. But the man in... | ||