Question

ORACLE相关问题,高手请进!!!

在PL SQL 里执行一条语句,当反正信息达到23000条时,弹出如下内容:
result set exceeds the maximum size(100M)
if necessary,you can explicitly confinue this query
应该就是所查结果超了,在哪里调这个100M值呢?

Answer 1

应该是你的查询结果集太大点OK一般可以继续的为了避免结果集太大，可以多加限制条件，或者用rownum < 10000来取前面多少条数据看

Answer 2

我以前也是用PL/SQL的，这个可能没法调吧，你ok以后应该继续查的把，就是数据量大。我现在都是用oracle 官方的oracle sql developer，很不错呀，刚出的2.1版本非常好，拿来用用吧，免费的，比用盗版的PL/SQL好吧，这个有官方支持，呵呵 下载地址：http://www.oracle.com/technology/products/database/sql_developer/index.html

Answer 3

这问题我还遇到过。官方说法：（11g）Activating Client-Side Query Cache. Setting up client-side query cache features involves setting a few simple parameters in the database’s initialization parameter file:CLIENT_RESULT_CACHE_SIZE defines the size of the client result cache for each OCI client process. CLIENT_RESULT_CACHE_LAG determines the maximum number of milliseconds before the OCI client query should execute a round trip to capture any data changes that might be applied to the existing cached client queries. Overriding Database Settings at the Client Level. Three additional OCI parameters can be set up at the client machine itself to override those set at the database level settings. These parameters are listed in the client machine’s SQLNET.ORA file:When a value for OCI_RESULT_CACHE_MAX_SIZE is set at the client level, it overrides the maximum size of each client’s result cache that’s set via CLIENT_RESULT_CACHE_SIZE. Two other parameters tell Oracle 11g how to set the maximum size of the result cache for any single client process. Parameter OCI_RESULT_CACHE_MAX_RSET_SIZE specifies the size in bytes; likewise, parameter OCI_RESULT_CACHE_MAX_RSET_ROWS limits the size based on the number of rows cached.

Answer 4

程序也可以导成文本或execl 等等呀,在plsql中可以点确定继续。这种程序查询少的话还行，多了的话整个数据库性能会有问题