From oracle-l-bounce@freelists.org Tue Sep 27 15:29:07 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8RKT7Hg002539 for ; Tue, 27 Sep 2005 15:29:07 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8RKT16H002510 for ; Tue, 27 Sep 2005 15:29:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 181C21EF2C1; Tue, 27 Sep 2005 15:28:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30294-08; Tue, 27 Sep 2005 15:28:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79F851EF0CA; Tue, 27 Sep 2005 15:28:56 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=bj5FICBXDINROJg+50cEsJ9C7PM5hTiOg0hVdqDj+yjVkogmtZ/2fJZ5ZkTMLJB4qkTh//ehkhjD1eKw0Mtxk/zZETQgU/OeRbTF83tQavQ+/FJPAeJEd5AQw3MKmCOrxXA27JNe84kkrOuVj8JcTZOKfQz242YEqsJ/Cj4CKnk= Message-ID: Date: Tue, 27 Sep 2005 16:27:00 -0400 From: Paul Baumgartel To: oracle-l@freelists.org Subject: Re: null columns and memory? In-Reply-To: <092720052015.29170.4339A86100004DB8000071F22207001641079D9A00000E09A1020E979D@comcast.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_12952_780084.1127852820297" References: <092720052015.29170.4339A86100004DB8000071F22207001641079D9A00000E09A1020E979D@comcast.net> X-archive-position: 25961 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: paul.baumgartel@gmail.com Precedence: normal Reply-To: paul.baumgartel@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_12952_780084.1127852820297 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline In memory where? Space is reserved in DB blocks (formerly via PCTFREE, now via ASSM) for operations that increase the storage requirements of the block--such as updating a character string to a longer string, or supplying a value in a column that formerly contained none. On 9/27/05, ryan_gaffuri@comcast.net wrote: > > Someone at work told me the following. Having trouble confirming it in th= e > docs. > If you have a table with a nullable varchar column. If the field is left > null no space will be taken up in the database. However, space will be > reserved in memory for the column. Is this correct? > -- Paul Baumgartel paul.baumgartel@aya.yale.edu ------=_Part_12952_780084.1127852820297 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline In memory where?  Space is reserved in DB blocks (formerly via PCTFREE, now via ASSM) for operations that increase the storage requirements of the block--such as updating a character string to a longer string, or supplying a value in a column that formerly contained none.


On 9/27/05, ryan_gaffuri@comcast.net <ryan_gaffuri@comcast.= net > wrote:
Someone at work told me the following. Having trouble confirming it in= the docs.
 
If you have a table with a nullable varchar column. If the field is left null no space will be taken up in the database. However, space will be reserved in memory for the column. Is this correct?



--
Paul Baumgartel
paul.baumgartel@aya.yale.edu

------=_Part_12952_780084.1127852820297-- -- http://www.freelists.org/webpage/oracle-l