Database Administration (MOSC)

MOSC Banner

Extent Management

edited Jul 24, 2009 2:26AM in Database Administration (MOSC) 3 commentsAnswered
 Hi,
Easy one here, but a bit confusing documentation regardin extent storage clauses and LMT's.

According to the Concepts manual regarding extent management and storage clauses:

"The storage parameters INITIAL , NEXT , PCTINCREASE , and MINEXTENTS cannot be specified at the tablespace level for locally managed tablespaces. They can, however, be specified at the segment level. In this case, INITIAL , NEXT , PCTINCREASE , and MINEXTENTS are used together to compute the initial size of the segment. After the segment size is computed, internal algorithms determine the size of each extent."

According to the Administrator's Guide storage clauses:

" NEXT " In a dictionary-managed tablespace, the size, in bytes, of the next incremental extent to be allocated for a segment. The second extent is equal to the original setting for

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center