Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SMON's coalesce & PCTINCREASE
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?