Database Tuning (MOSC)

MOSC Banner

Database hang caused by partitioning job(reference partitions) blocking application sessions

edited May 28, 2014 12:00PM in Database Tuning (MOSC) 2 commentsAnswered

Environment:

Red Hat Enterprise Linux Server release 5.5

2 Node RAC

Issue:

Occasionally during the partitioning job runs(specifically during drop of reference partitions) the partitioning job goes through a deadlock with one of the application sessions, which gets cleared on timeout of 15minutes. Multiple application sessions are blocked during this period.

The partitioning job waits on a library cache lock and the application session waits on a row cache lock.

How they block each other is unclear.

A similar database with similar application logic but standalone and on a different OS does not have this issue.

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