Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SMON's coalesce & PCTINCREASE

SMON's coalesce & PCTINCREASE

From: Alan Moorman <alm2_at_XYZemail1.dss.state.va.us>
Date: Wed, 28 Jul 1999 12:07:56 -0400
Message-ID: <zPFn3.1$J5.45@dit4..state.va.us>


It's my understanding that the STORAGE clause on tablespaces is simply to establish defaults for objects created in that tablespace which don't explicitly state STORAGE.

That said, if the tablespace's STORAGE says PCTINCREASE 0, but every object created in the tablespace says PCTINCREASE 1, will SMON coalesce the tablespace?



When replying, please remove the "xyz" Received on Wed Jul 28 1999 - 11:07:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US