Maximum no of datafiles added by u in a single tspace
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Maximum no of datafiles added by u in a single tspace

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    Maximum no of datafiles added by u in a single tspace

    hi folks

    i wanted to know one thing

    What is the maximum number of datafiles u have added in a single tablespace.

    ie when a tablespace gets full we add a datafile manually , so how many datafiles you have added.

    This is without using AUTOEXTEND OPTION.

    REGARDS
    gajanan

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    read ref
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    abhay have u read the question properly.

    I am asking how many datafiles in maximum numbers one has added in a single tablespace

    i am asking this q based on experience and not book reference.

    I hope i have made clear

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by gajananpkini
    abhay have u read the question properly.

    I am asking how many datafiles in maximum numbers one has added in a single tablespace

    i am asking this q based on experience and not book reference.

    I hope i have made clear
    Cool down. Had you read some basics you wouldn't have asked this question.

    Look into v$datafile for ts# and creation_time. You will find how many files each tablespace has and when they were created.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    hey boss

    i am asking u , from ur experience of working as a DBA how many datafiles (maximum) u have added in a single tablespace .

    i am not asking how to check from data dictationary ok

  6. #6
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    I think he is asking that

    In a Tablespace How many Datafiles we can Add ??

    Thanks
    vishal sood
    OCP 8

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Gajanan

    Depends upon the application really..If home grown i will go on adding 2Gb datafiles and i would prefer it that way..not autoextend my datafiles..

    I ahve some ERP applications where the daatfiles for a tablespace is around 300+ there are some other applications where the datafiles are in the range of 128.

    some applications we purge old data after some specified years so the space in the datafile is reused and we have around 20-30 datafiles only..

    so teh answer is not very str8 forward it really depends.


    regards
    Hrishy

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Maximum per tablespace: Operating system dependent; usually 1022.

    Maximum per database: 65533.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    gajanan's just asking how many you have used, not how many is a good idea, or how many are theretically possible. Those would just be bonuses.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175
    That might change from version to version, but the current Reference manual (Physical Limits) - 9i will always show you the number.


    HTH,

    clio_usa - OCP 8/8i/9i DBA

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