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_at_comcast.net <ryan_gaffuri_at_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_at_aya.yale.edu
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 27 2005 - 15:29:07 CDT
