DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: strange query output from dba_tables

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width