Re: Oracle Storage Parameters

Hello Kelly,

I think you can set the initial to less than the default if you want. The default is used only when you omit the storage clause in your create table statement.

Matthew

townselk_at_my-dejanews.com wrote in message <6vktjk$vne$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I'm a new DBA and I have a storage question for anyone who wants to
respond.
>I was reading in my Oracle 7 server: Data Administration Student Guide that
>the inital extent parameter defaults to 5 data blocks. My question is a
>two-fold questions as it relates to the STORAGE clause. On my system, the
>DB_BLOCK_SIZE = 4k..if you have a small table do you still have to specify
a
>size for the INITIAL PARAMETER if Oracle already will default to app. 20k
by
>default (4096 *5). What sizing takes precedence? The default value or if
>you were to size the initial extent parameter less than the default say,
for
>example, 10k.
>
>Please relieve my confusion
>
>Thanks,
>
>Kelly
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Oct 09 1998 - 07:46:59 CDT