What does INCREMENT_BY mean?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: What does INCREMENT_BY mean?

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    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
    Posts
    807
    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



    fix:

    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