Re: null columns and memory?

From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>

To: oracle-l@xxxxxxxxxxxxx

Date: Tue, 27 Sep 2005 16:27:00 -0400

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@xxxxxxxxxxx <ryan_gaffuri@xxxxxxxxxxx> 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@xxxxxxxxxxxx