Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SPOOL Problem
Looks like a memory leak bug. Can’t
imagine the SQL*Plus would intentionally need to allocate memory for the entire
output stream.
The reason for the variability in your
results probably relates to the amount of memory available on the heap at the
time.
Cheers
Graeme Farmer
Consulting Architect
MMS Architecture & Solutions Design
From:
oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of "Yongping Yao"
<yaoyongping@gmail.com>
Sent: Wednesday, 7 June 2006 12:13
PM
To: oracle-l@freelists.org
Subject: SPOOL Problem
Hi all,
I don't know if it's off topic, but I met it in SQLPlus.
I SPOOLed the output into a text. When the file reached to GB, an
exception "xrealloc: cannot reallocate 706258176 bytes (0 bytes
allocated)" occurred. I tried again and again. Everytime the exception
occurred with different file size. Sometime it was about 3G, sometime it's near
1G ( and of cource the number in the error is different everytime ).
-bash-2.05b$ uname -a
Linux zszj2 2.4.21-27.EL #1 Wed Dec 1 22:08:15 EST 2004 i686 i686 i386
GNU/Linux
That's my OS. I also tried on Solaris 8, just the same. So I think it's
not a 32bitOS or 64bitOS problem. The database is 9.2.0.1.
Have anyone met and solved it?
Thank you in advance.
--
Learning Oracle, UNIX/Linux...
Love
Blog: http://spaces.msn.com/members/yaoyp/
--
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
-- http://www.freelists.org/webpage/oracle-l Received on Tue Jun 06 2006 - 21:26:27 CDT