MV refresh Done With DBMS_REFRESH Running Slow With Involved Spatial Indexes
(Doc ID 2910917.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Spatial and Graph - Version 18.104.22.168 and later
Information in this document applies to any platform.
Refreshing MVs with DBMS_REFRESH runs very slowly.
Dropping the involved Spatial Indexes improves performance greatly, but a permanent solution is needed.
Upon checking involved processes with "ps -ef|grep csdgdilt|grep _j0" we find that these are executing:
SELECT /* chk_journal_reg */
WHERE sid = :1
AND sdo_txn_idx_id = :2
AND indexptniden = :3
AND operation = :4
AND rid = :5
Upgrade from 12c to 19c
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document