Home -> Usenet -> comp.databases.oracle -> Yet, another Extent question ?

Yet, another Extent question ?

From: Stan Novinsky <stan_novinsky_at_jhuapl.edu>
Date: 1995/08/22
Message-ID: <41ddvv$mm2_at_aplinfo.jhuapl.edu>#1/1 






From reading Oracle manuals and associated postings, I have a 
question about extents that may sound crazy, but..



  If the manuals say to allocate the minimum amount of Extents 
  possible for objects for the purpose of better response time
  and contiguous allocatin, why is there a MIN and MAXEXTENTS ???



  If I have a tablespace that is is defined as USER.DBF residing
  on DISKA: and is 23M why can't the INITIAL and NEXT storage
  qualifiers be used to allocate the maximum amount of space and
  don't worry about MINEXTENTS and MAXEXTENTS



    CREATE TABLESPACE user

      DATAFILE 'DISKA:[FILES]USER.DBF' SIZE 22M reuse
         DEFAULT STORAGE (
                     INITIAL 11M
                     NEXT    11M
                     MINEXTENTS 1
                     MAXEXTENTS 1
                     PCTINCREASE 0); 





Thanks 


stan_novinsky_at_jhuapl.edu





Received on Tue Aug 22 1995 - 00:00:00 CEST












Original text of this message