3 Replies Latest reply: Oct 5, 2010 5:23 PM by Robert Ponder RSS

    Base Table Maximum limt.

      How many maximum number of column a siebel Base Table can hold
      for ex:-S_SRV_REQ
        • 1. Re: Base Table Maximum limt.
          I guess as many as your DB (Oracle, SQL Server or DB2) can manage.
          But I think that as soon as you hit the maximum column limit, you really need to to rethink your data model.

          If you mean rows, I think that you have to think about archiving strategies.
          • 2. Re: Base Table Maximum limt.
            Hi Saransh,

            If you are using an Oracle database then you can have approximately 1000 columns in one table. (ora-01792.ora-code.com)
            However, if you are making such huge number of columns then you sure need to do a validation as to the need for these as this will have a very adverse impact on the performance of your siebel application as well.

            Hope this helps,
            With Regards,
            Tanmay Jain

            Edited by: tanmay.jain on Oct 5, 2010 2:47 PM
            • 3. Re: Base Table Maximum limt.
              Robert Ponder

              We have seen some very large Siebel tablels.

              One of our customers has nearly 1 billion records in s_evt_act.

              Another customers has 1.5 billion in usage table.

              Tuning Siebel with tables this large is lot of fun for us.

              Robert Ponder