确定SQL结果集的大小(以KB为单位) [英] Determine the size of a SQL result set in KB

问题描述

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

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