Dear AskTom Team, first of all thanks for all the support you are giving all of as for some many years. I already read many of your answer about the topic PL/SQL Collection slowing sql execution. I alredy tried all the hints (such for example the cardinality hint) you suggested b...

Dear Ask Tom team, Could you please clarify why using a longer declared size of VARCHAR2 affects CPU consumption during SQL execution? Assuming that there are no essential flaws in my benchmark design. Based on my findings, the declared size of VARCHAR2 does impact SQL performanc...

Hi, I am working on a Archiving application. Aim is to bring year and years of data from Production DB into another DB named as Archiving DB and then delete from the Production DB. Currently I am testing deletion on an Archiving DB to test my package performance. I am running I q...

Why Do /*+ materialize */ Hints Generate Redo? What modifications are materialized subquery factoring clauses making that is needing to be protected by redo? Session A executes a SELECT statement six times. The first three executions are without the /*+ materialize */ hint and no...

Hi I have a query that is spooling results to a text file via an automated process Monday to Friday. Below are the variables that are used in the query. The queries returns data in Oracle SQL Developer, but returns only the headers with no data when I use Toad for Oracle 17.0 Pat...