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

Thread: Database Design

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    34

    Question

    Hi Friends,

    WE are having following software and hardware.
    Oracle 8i Release 2(8.1.6) and Operating System is Sun Solaries 2.8
    on Sun E6500 Machine.Database size will 3 terabytes.

    We are going to maintain inserts and select operation in this database. No update is going to occur. At presently I am planning to design one table and partiton ,subpartition and index on 16 different
    columns . We r able to maintain only three days of data , old data is truncated regulary , Database is in no archivelog mode.We r having backup at NIC side . Table's max record size is 360 bytes and 82 fields but around 32 fields are generally remain null.
    At presently I am planning for one table and partition ,subpartition and index it and trying to distribute data on EMC disks as i can .
    But I want to know one table will give a better performance or i should go for multiple tables,while one table is possible.
    Waiting for ur feedback.
    Thanks and have a great Day.
    Jayesh

    db block size is 8k,
    table will be of 1 tb,
    we r having daywise range partition
    we r having 16 diffrent index and also partitioned

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    I will go with multiple tables given this option...
    Radhakrishnan.M

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You do not need multiple tables. Single table is enough.
    Since you are going to have day wise partition, every day you can drop the 3 days old partition and add one new partition. This can be achived through a automated procedure or Shell Script.

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