Skip to Content
author's profile photo Former Member
Former Member

abnormal increase in the oracle data base of XI dev

Hi Experts,

The size of the oracle data base for SAP-XI is increased by 9% abnormally in 1 day, where as 1% increase in the oracle data base size normally takes 1 to 2 weeks.

What could be the problem? Please give me some links or some idea how to check to know what causes this problem.

Thnx

Subbu

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 12:49 PM

    Hi Subbu,

    How many messgaes are proceessing every day?

    Databse size will grow because messages will store in the database.

    Did you configure tretention period (to delete archive messages)?

    Regards

    Ben

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Subbu,

      By default the max number of entries for the table SXMSPMAST is 1.000.000 entries, considered to be XI messages.

      A DROP_MAX_TABLE_LOAD value of 90% meaning 900.000 messages are stored in the system until the switch and deletion is triggered.

      Example:

      Retention Period = 30 days

      Throughput = 10 000 messages / day

       first time for triggering a table switch will be after 90 days (as fill level is reached).

      Any message of age 30 days and older will be marked for deletion. Messages of age 0 – 29 days are kept, which means 61 days worth of messages will be deleted.

      From that point on a “delta” growth of 61 days until the next deletion occurs.

      This results in the following peak space usage considering 1Mb/entry: 900.000 MB + 290.000 MB = 1,19 TB for copy and dropping procedure

      Regards

      Ben

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 03:58 PM

    Hi Subbu,

    use following reoprt to check the number of messages

    RSXMB_SHOW_REORG_STATUS

    Regards

    Ben

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 01, 2012 at 11:11 PM

    self resloved.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.