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

Thread: IOT with partitioning for Linux-64-bit

  1. 04-20-2005, 11:51 AM #1
    andron
    andron is offline Junior Member
    Join Date
    Apr 2005
    Posts
    1

    IOT with partitioning for Linux-64-bit

    Hi all,
    I need your advise about planning database storage.
    We have the database with partitioning for IOT tables.
    We used IOT for time-series data.
    These tables belong one tablespace.The tablespaces was
    split by 2000 MB data files and total size is 68GB ..
    We are going to create new database with the same schema.
    Should we create one or three big data files or create a lot small.
    We will use Linux 64-bit.What is the better way for IOT with partitioning ?

    Thanks,

    Andrey
    Reply With Quote Reply With Quote
  2. 04-20-2005, 12:52 PM #2
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    The size of your data files is more a factor of MTTR (mean time to recovery). Takes longer to recover a larger data file.

    A couple weeks ago I heard of a guy with a tablespace consisting of one 500 Gigabyte datafile. (10g "bigfile") .. running on a mac.

    Guess it's possible, but not something I would do.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
  3. 04-20-2005, 01:21 PM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by KenEwald
    The size of your data files is more a factor of MTTR (mean time to recovery). Takes longer to recover a larger data file.

    A couple weeks ago I heard of a guy with a tablespace consisting of one 500 Gigabyte datafile. (10g "bigfile") .. running on a mac.

    Guess it's possible, but not something I would do.
    gee whizz, bet that took some time to create.

    Also if you have separate disks, just made sure you spread it across all of them
    Reply With Quote Reply With Quote
  4. 04-20-2005, 02:07 PM #4
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by KenEwald
    The size of your data files is more a factor of MTTR (mean time to recovery). Takes longer to recover a larger data file.
    Would that also apply with RMAN?
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE
    Reply With Quote Reply With Quote
  5. 04-20-2005, 02:18 PM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes, if you need to recover a 10Gb from tape, will take longer than a 2gb file for example. If you are restoring a whole database wont make much difference
    Reply With Quote Reply With Quote
  6. 04-20-2005, 02:22 PM #6
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by davey23uk
    yes, if you need to recover a 10Gb from tape, will take longer than a 2gb file for example. If you are restoring a whole database wont make much difference
    sorta of maybe - depeneds on how many blocks in the datafile ever contained data
    - so if you have a new 10gb df with zero blocks it could conceivably recover faster than a 2gb df all packed up with blocks that at some time had/has data
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width