Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Depuration process to XOM ORDER_HISTORY table OROBv15 Database

Hi Gurus.


Can you help us with the following doubt please? we are facing performance issue on Order Broker DB when we did selects to XOM_ORDER_HISTORY table, rigth now we have more than 26 millions records on it and we want to know two things.


1.- 26 millions of record is enough information to increase load DB and provoke perfomance issue ?


a) recently we are detected the following selec instrucction on that table that provoke sever perfomance issue on DB, it the folowing:


SELECT LOCATION.LOCATION_ID AS LOCATION_ID , MAX(ACTIVITY_DATE) AS ACTIVITY_DATE

FROM XOM_STATUS_HISTORY

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center