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

Other related posts: