以 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.
相关文章