Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

IP17 Upgrade - Cancelling Upgrep

edited Nov 19, 2017 4:05AM in Siebel System Admin, Install and Upgrade (MOSC) 3 commentsAnswered ✓

Upgrep seems to run for a long time

DBA says that it seems to load millions of records due to the IN clause and is causing great amount of delay (this query seems to be running for more than 6 hours now)

20 million records in activities in our systems. 

UPDATE S_EVT_ACT_CAL

   SET TIME_ZONE_NAME =

(SELECT S_TIMEZONE.NAME

FROM S_TIMEZONE, S_CONTACT, S_EVT_ACT

WHERE S_EVT_ACT_CAL.PAR_ROW_ID = S_EVT_ACT.ROW_ID

AND S_CONTACT.ROW_ID = S_EVT_ACT.OWNER_PER_ID

AND S_TIMEZONE.ROW_ID = S_CONTACT.TIMEZONE_ID)

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