This discussion is archived
3 Replies Latest reply: Nov 13, 2012 10:29 PM by Timo Hahn RSS

Why PS_TXN transaction sequence is configured as 50 by defult

SreeniGaddam Newbie
Currently Being Moderated
Please can you help me understand why PS_TXN_SEQ is configured as 50 by default ...
generally it should be set it as 1

Thanks for your inputs

Sreeni
  • 1. Re: Why PS_TXN transaction sequence is configured as 50 by defult
    Puthanampatti Guru
    Currently Being Moderated
    looks like the sequence "increment by" param configured as "1 increment by 50".

    Database Objects Used For Application Module State Management
    The PS_TXN Table
    The PS_TXN table stores snapshots of pending changes made to BC4J application module instances. The table manages the B-Tree storage of rows. The snapshot information is stored as an XML document that encodes the unposted changes in an application module instance. Only pending data changes are stored in the snapshot, along with information about the current state of active iterators (i.e. "current row" pointers information). The value of the COLLID column corresponds to the value returned by the ApplicationModule.passivateState() method.

    The PS_TXN_SEQ Sequence
    This sequence is used to assign the next persistent snapshot Id for Application Module pending state management. If the PS_TXN table contains any rows at the time this sequence is created, the sequence is created so that is STARTS WITH the integer that is one greater than the MAX(COLLID) value from the rows in PS_TXN.
  • 2. Re: Why PS_TXN transaction sequence is configured as 50 by defult
    SreeniGaddam Newbie
    Currently Being Moderated
    Thanks for your response ..is there any specific reason behind increment by "50"
    Will there be any any impact if we change it to increment by 1
  • 3. Re: Why PS_TXN transaction sequence is configured as 50 by defult
    Timo Hahn Oracle ACE
    Currently Being Moderated
    You only generate more traffic to the db this way. Add you don't control the user of this sequence I don't see a reason way you want to set the increment to 1.

    Timo

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points