Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL * Plus Buffer (8.1.5)

SQL * Plus Buffer (8.1.5)

From: Sachin Puri <sachin_at_siworldwide.com>
Date: Tue, 16 Jan 2001 18:37:06 +0530
Message-Id: <10743.126766@fatcity.com>


I am trying to execute a procedure whose output is exceeding the buffer cache and is giving the error
buffer cache exceeded and the proc is not able to execute fully. I have set the buffer length to 2000 and width to 1000 and sql*plus won't allow me increase its length or width anymore. All DBAs what should i do?

Rgds,
Sachin Puri Received on Tue Jan 16 2001 - 07:07:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US