Sql – Determine the size of a SQL result set in KB


I am hoping to find how I can get the kb size of a result set in OracleDB.
I am not an sysadmin, but often run queries that return over 100k rows and I would need to find a way to determine what is the total kb size.
thank you

Best Solution

In SQL*Plus:


FROM emp
WHERE rownum <= 100;

        27  recursive calls
         0  db block gets
        19  consistent gets
         4  physical reads
         0  redo size
     **11451  bytes sent via SQL*Net to client**
       314  bytes received via SQL*Net from client
         8  SQL*Net roundtrips to/from client
         0  sorts (memory)
         0  sorts (disk)
       100  rows processed

To use AUTOTRACE requires the PLUSTRACE role, which is not granted by default. Find out more.