Database Administration (MOSC)

MOSC Banner

Locking issues and contentions possibly caused by materialized view

We are using Oracle 19.7 on Linux.

I'm suspecting a materialized view to be the cause of massive locking and contention issues.

We have added a materialized view a couple of months ago, to address performance problems by some expensive queries.

While this works fine most of the time, occasionally we see some contentions and locking issues. End users are reporting long response times by the application, and sometimes timeouts.

I'm not sure the issues are all caused by the materialized view, since there have also been other functional changes to the application.

But the logs show a lot of erros related to the materialized view and materialized view Log

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