Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Xstore - Locate DB spiked when processing order having 50 plus items

edited Mar 31, 2020 5:01AM in Retail Point-of-Service Solutions (MOSC) 3 commentsAnswered

Good morning MOSC !

  We have a situation in one of our client, where Locate DB spiked. There was a large order that was processing at the time of major impact that included over 60 items.  Because of this,  xml.log did not appear to have excessive requests, it was one large request.  This was found to be a real customer order that occurred but this appears to have been the beginning of the event that caused Locate servers to spike and the sql db to fail.    

Processing 60 items should not cause an issue. But still wanted to know what could have caused the cpu spikes and db failure? Please let me know if you know any cases similar to this and provide some insights?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center