Expand your Oracle Tuning Tools with dbms_utility.expand_sql_text
Expand an Oracle View to Full SELECT Text When working on a view composed of SELECT statements on...
Expand an Oracle View to Full SELECT Text When working on a view composed of SELECT statements on...
Recently, Pythian was engaged to investigate the performance of an application that was reported as...
Perhaps you have been approached by a client or manager and tasked with troubleshooting one or more...
If you are using a remote Oracle database service, such as Oracle’s Autonomous Transaction...
When Oracle introduced version 12.1 of the RDBMS, an interesting new parameter was included:...
Have you ever logged on to a Linux machine, only to be greeted by a prompt requesting you make some...
What is SYSQL? Recently Tanel Poder and I were discussing the use of Linux command pipelines for...
Select vs Assign It isn’t unusual to see PL/SQL that contains select columns into variables from...
When the “wrong” index is used for a SQL query, it’s sometimes a struggle to coerce Oracle to use...
As part of a recent project, I installed the Oracle Cloud command line utilities (oci) on the...