oracle缓冲池大小如何查询,如何增加Oracle SQL Developer中的缓冲区大小以查看所有记录？...

https://forums.oracle.com/forums/thread.jspa?threadID=447344

相关部分内容如下：

There’s no setting to fetch all records. You wouldn’t like SQL

Developer to fetch for minutes on big tables anyway. If, for 1

specific table, you want to fetch all records, you can do Control-End

in the results pane to go to the last record. You could time the

fetching time yourself, but that will vary on the network speed and

congestion, the program (SQL*Plus will be quicker than SQL Dev because

it’s more simple), etc.

工具栏上还有一个“全部获取”按钮。

FWIW请仔细检索所有记录，对于非常大的记录集，可能会导致您有各种内存问题。

据我所知，SQL Developer在后台使用JDBC来获取记录，并且JDBC setMaxRows()过程设置了限制，如果你可以改变这个(可能不受支持)，那么你可以改变SQL Developer行为。