Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Serial Number Performance and DB Locking

Hi All,

Can anyone assist with an issue we are having with our SBO2007 PL 42...

There are 8 million Serial Numbers in the system with an average of 1 million Serial Numbers per Item (8 Items). - Table OSRI

There are 40 milion Transactions in the system with and aveage of 5 Transactions per Serial Number.

When the Serial Number Selection Screen opens in a Marketing Document, it slows the entire organisation down and it seems like there are Locks in the Database that are causing this.

Can anyone help me understand why this occurs and if there is any way of overcomming this "Serious" Issue?


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question