-
strange query output from dba_tables
select extents,initial_extent,next_extent,freelists from
dba_segments where segment_name in ('BALLOTT');
EXTENTS INITIAL_EXTENT NEXT_EXTENT FREELISTS
---------- -------------- ----------- ----------
87 65536
select pct_free, pct_used, initial_extent,next_extent,ini_trans,max_trans
from dba_tables where table_name in ('BALLOTT')
PCT_FREE PCT_USED INITIAL_EXTENT NEXT_EXTENT INI_TRANS MAX_TRANS
---------- ---------- -------------- ----------- ---------- ----------
10 65536 1 255
QUESTION:
Any reason why pct_used,next_extents,freelists are
not showing from the two above scripts?
I thought at least the default values should be appear
-
using automatic segment management and LMT with system managed extents huh
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
|