以 KB 为单位确定 SQL 结果集的大小

问题描述

我希望找到如何在 OracleDB 中获取结果集的 kb 大小.我不是系统管理员，但经常运行返回超过 100k 行的查询，我需要找到一种方法来确定总 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

推荐答案

在 SQL*Plus 中:

In SQL*Plus:

SET AUTOTRACE ON

SELECT *
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

要使用 AUTOTRACE 需要 PLUSTRACE 角色，默认情况下不会授予该角色.了解更多.

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

这篇关于以 KB 为单位确定 SQL 结果集的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！