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

Hybrid View

  1. #1
    Join Date
    Jun 2002
    Longmont, Colorado

    What does INCREMENT_BY mean?

    When creating a tablespace and specifying autoextend on on the datafile, you have an option to specify the NEXT value for extending.

    When you query dba_data_files, this reflects the INCREMENT_BY column. But when I specify a NEXT value of 500K, the INCREMENT_BY column in dba_data_files show 63.

    What units is this value in? Blocks?

    It appears that it would...

  2. #2
    Join Date
    Oct 2002
    From metalink

    Doc ID: Note:155910.1
    Subject: What Is The Unit Of INCREMENT_BY Column Of DBA_DATA_FILES?
    Type: HOWTO
    Status: PUBLISHED
    Content Type: TEXT/X-HTML
    Creation Date: 22-JUN-2001
    Last Revision Date: 05-SEP-2002

    goal: What is the unit of INCREMENT_BY column of DBA_DATA_FILES?
    fact: Oracle Server - Enterprise Edition 8
    fact: DBA_DATA_FILES view
    fact: INCREMENT_BY column


    The unit is the number of database blocks

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.