what is the max. number of records in a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: what is the max. number of records in a table

Hybrid View

  1. #1
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Hi,
    I would like to know what is the max number of rows we
    can put in partitioned table or per partition.
    Hear i have to insert 1.2 billion per partition.
    i would like to know your openion.

    Thank

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I wouldn't think so...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Here is my hardware + software configuration
    Sun E 3500. 4x400MHZ CPU, 2 GB RAM. 2xA5200 Disk arrays.
    Veritas VM, Veritas QuickI/O filesystem.

    Thanks

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    unlimited

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Oracle allows two bytes for row numbers, so theoretically they could go as high as 65535 rows in a block. However, given the minimum row length (11 bytes) and maximum database block size (32K), the pratical limit on the number of rows in a block is in fact only 2970.

    For calculation purpose Let us say 3000 rows in a block of 32K (32768).

    The size of a datafile for a Oracle tablespace is 4 GB ( 4,294,967,296 bytes).

    # of rows in a 4GB datafile = (4294967296/32768)*3000 = 393,216,000 rows.

    Assume a tablespace can support 1022 datafiles.

    So max # of rows for a table = 393216000 * 1022 = 401,866,752,000 Rows.

    So a table can have maximum of 400 billion rows if the row is size 11 bytes.

    If I want to store 400 billion rows in a table, then I would not use Oracle, but Teradata.

    Max # of partitions in a table = 64000

    So a table can have (64000 * 400) billion rows.


    [Edited by tamilselvan on 09-24-2001 at 02:32 PM]

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