The meaning of BYTES in user_segments table
652398Dec 31 2012 — edited Jan 10 2013The official explanation for user_segments table is:
USER_SEGMENTS describes the storage allocated for the segments owned by the current user’s objects. Its columns (except for OWNER, HEADER_FILE, HEADER_BLOCK, and RELATIVE_FNO) are the same as those in DBA_SEGMENTS.
When we create a table, there is no explicit limitation for that table size. While we often watch through PLSQL tools:
storage
(
initial 64K
minextents 1
maxextents unlimited
);
When selecting user_segments, the value of MIN_EXTENTS is 1 and the value of MAX_EXTENTS is 2147483645.
My question is that in user_segments, the field of BYTES stands for the actual bytes of current table or the permitable maximum bytes of current table? Or stands for the actual bytes of current segment or the permitable maximum bytes of current segment?
Thanks a lot.