-
Can anybody help me with this? I used the following dba_views on one table(emp) and got this
SQL> select segment_name, segment_type, bytes, blocks,tablespace_name from dba_segments where segment_name = 'EMP';
SEGMENT_NAME SEGMENT_TYPE BYTES BLOCKS TABLESPACE_NAME
------------- ------------- ---------- ---------- ----------------
EMP TABLE 10485760 2560 EMP_TBS
SQL> select segment_name, bytes, tablespace_name from dba_extents where segment_name = 'EMP';
SEGMENT_NAME BYTES TABLESPACE_NAME
------------- ---------- ----------------
EMP 10485760 EMP_TBS
NOTE:the initial extent is 5242880, next extent is 5242880,max_extents is 450.
Question:Does the bytes(10485760) mean that is the number of bytes that has been used so far out of the number allocated?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|