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

Thread: growing tablespace

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    growing tablespace

    Hi,

    If I have a tablespace containing two datafiles: data1.dbf, data2.dbf, how can I ensure both files grow evenly when new tables are created and data are inserted?

    If I started out with only one datafile: data1.dbf and later decided to spread out the data to newly created data2.dbf, how do I ensure that?

    Thanks,

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Call me Sherlock, but why not only have one datafile first... and then another when it's required.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    A woman gets onto a bus with her baby.

    The bus driver says, "That's the ugliest baby that I've ever seen. Ugh!"

    The woman goes to the rear of the bus and sits down, fuming. She says to a man next to her, "The driver just insulted me!"

    The man says, "You go right up there and tell him off. Go ahead, I'll hold your monkey for you."

  4. #4
    Join Date
    Apr 2001
    Posts
    257
    grjohnson,

    > and then another when it's required.

    You basically point out my question: when is it required? If I set it to grow "unlimited", am I pretty safe?

    I currently have only one file for the tablespace. However, it now grows to 6GB and I'd like to have the second datafile. Honestly, I am not sure if it's necessary because I have 0+1 RAID. I am just curious how Oracle and what settings determine which table/data goes to which datafile, if I don't explicitly speicify it?

    Is it still preferred to have several datafiles for a single tablespace even if it's 0+1?

    Thanks,

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    If I worked with a DBA who set the datafile size to UNLIMITED AND AUTOEXTEND ON, I'd kick his arse from one side of the room to the other. That is STUPID IMO! Set AUTOEXTEND ON BUT ALSOset it to a reasonable MAXSIZE (Mine is 2GB for < 8i, 4GB >= 8i). BUT, it also depends on DB size and filesystems. When do you add another? When it hit's your critical limit... maybe 80 - 90% of capacity... whatever. This is why we monitor the DB. Also, the "A" in DBA does stand for Adminstration.
    OCP 8i, 9i DBA
    Brisbane Australia

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: growing tablespace

    Originally posted by a128
    Hi,

    If I have a tablespace containing two datafiles: data1.dbf, data2.dbf, how can I ensure both files grow evenly when new tables are created and data are inserted?

    If I started out with only one datafile: data1.dbf and later decided to spread out the data to newly created data2.dbf, how do I ensure that?

    Thanks,
    The extents are allocated to multiple datafiles for a tablespace in a round-robin fashion. So at some point all files are almost equally large.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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