3 Replies Latest reply: Jun 7, 2013 2:42 AM by 561250 RSS

    number of records in Oracle 11G XE

    561250
      Hi.

      I'm establishing a database regime for my phd and am looking for a suitable database system.

      I'm looking for a simple data storage without the need for any complex queries or application connected to the database.

      In terms of numbers (if thats possible to say) would the XE be suitable for approx 14 mill records (in 15 columns with an average of 10 char pr column) plus an increase in number of records of approx. 100.000 each year for the next 5 years.

      Hope that was comprehansable.

      Best regards

      Nicolai
        • 1. Re: number of records in Oracle 11G XE
          Paul M.
          would the XE be suitable for approx 14 mill records (in 15 columns with an average of 10 char pr column) plus an increase in number of records of approx. 100.000 each year for the next 5 years.
          Oracle Database Express Edition 11g Release 2 has known limitations. See Licensing Restrictions
          • 2. Re: number of records in Oracle 11G XE
            Udo
            would the XE be suitable for approx 14 mill records (in 15 columns with an average of 10 char pr column) plus an increase in number of records of approx. 100.000 each year for the next 5 years.
            Oracle Database Express Edition 11g Release 2 has known limitations. See Licensing Restrictions
            ... but it probably will be able to fulfill your requirement:
            14 mill + 500k makes 14.5 mill in total.
            Simple maths would be:
            14.5 mill * 15 * 10 result in approx. 2 GB of data. Add some overhead for indexes and other things you may or may not need to store aside from your main data pool the 11 GB allowed to be used in 11.2 XE should be sufficient.
            On the other hand, you may have some restrictions on performance, since memory and cpu usage are limited as well, so processing large amounts of data at once (in a single query) might result in poor response times.

            -Udo
            • 3. Re: number of records in Oracle 11G XE
              561250
              Hi.

              Thanks for your reply and sorry for my late reply.

              It was helpfull and i have established a system with the oracle 11g xe

              :-)

              Nicolai