Database Administration (MOSC)

MOSC Banner

Blocking Locks and FK Indexing

edited Dec 4, 2008 2:06PM in Database Administration (MOSC) 1 commentAnswered

 

We recently upgraded a database to 10.2.0.4, and delivered a new vendor supplied schema.  We seem to be experiencing more blocking lock situations since the upgrade.

We are looking at traces and investigating serveral solutions and would like an opinion on one general possibility.

There are several hundred un-indexed foriegn key columns in the new database.  Oracle docs seem to conflict on whether this could be a contributing factor. The Developers Guide says to "Index foreign keys unless the matching unique or primary key is never updated or deleted". In our case, PK columns are defintely not updated, and there is very little deleting overall. 

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