Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 11007 invoked from network); 6 Jun 2006 22:02:20 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 6 Jun 2006 22:02:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E5B3D34DA74; Tue, 6 Jun 2006 23:02:19 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00380-06; Tue, 6 Jun 2006 23:02:19 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5F4D834DA52; Tue, 6 Jun 2006 23:02:19 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 06 Jun 2006 23:01:34 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ADDEE34D3E9 for ; Tue, 6 Jun 2006 23:01:34 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32625-04 for ; Tue, 6 Jun 2006 23:01:34 -0400 (EDT) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 56B0D34DB25 for ; Tue, 6 Jun 2006 23:01:34 -0400 (EDT) Received: by py-out-1112.google.com with SMTP id i49so83555pyi for ; Tue, 06 Jun 2006 20:01:33 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=a3KPTuixkzUl3hNYWw3KJa4vb9Jl0aACFQydbLXc9SlUGjN9biBnDA99mn7gBBrvJ2cKNpd6xSa/68pWr5Woq7PDp3Kk8mpEGeIVpMADJ4HwPmeyxZE5ZXUqEO6fniA+8voF7Cd4jeeq89UpYZE5FWSxIHdVy9XaifHqD3mVds4= Received: by 10.35.12.13 with SMTP id p13mr36448pyi; Tue, 06 Jun 2006 20:01:33 -0700 (PDT) Received: by 10.35.88.10 with HTTP; Tue, 6 Jun 2006 20:01:33 -0700 (PDT) Message-ID: <706468990606062001u43a57505j867064b361f80e1a@mail.gmail.com> Date: Wed, 7 Jun 2006 11:01:33 +0800 From: "Yongping Yao" To: "Graeme.Farmer@mincom.com" Subject: Re: SPOOL Problem Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5595_2618115.1149649293303" References: X-archive-position: 35692 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: yaoyongping@gmail.com Precedence: normal Reply-to: yaoyongping@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_Part_5595_2618115.1149649293303 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thank you for your reply. You mean it's a Oracle Bug or maybe a SQL*Plus bug? On 6/7/06, Graeme.Farmer@mincom.com wrote: > > 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. > > -- > Yao Yongping > Learning Oracle, UNIX/Linux... > Love Reading, Classical Music, Philosophy, Economics etc. > 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. > > > -- Yao Yongping Learning Oracle, UNIX/Linux... Love Reading, Classical Music, Philosophy, Economics etc. Blog: http://spaces.msn.com/members/yaoyp/ ------=_Part_5595_2618115.1149649293303 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thank you for your reply. You mean it's a Oracle Bug or maybe a SQL*Plus bug?

On 6/7/06, Graeme.Farmer@mincom.com <Graeme.Farmer@mincom.com> wrote:

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.

--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
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.

 




--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog:   http://spaces.msn.com/members/yaoyp/ ------=_Part_5595_2618115.1149649293303-- -- http://www.freelists.org/webpage/oracle-l