Database Administration (MOSC)

MOSC Banner

Is ORA-02049 is only limited to transactions that traverse to multiple databases

Hi,

I'm having an index concurrency on may database (base on index root split) and the transactions are concurrently waiting for it until they timedout.

the clients received error below:

ORA-02049: time-out: distributed transaction waiting for lock

my understanding for this distributed is that this call must involve at least 2 databases, one is local and one is remote.

But these client transactions did is to insert on the local history_table and not any remote table.

Planning to visit the parameter distributed_lock_timeout (=60) and increase it, but would this help if the transaction is local only and not distributed to a remote database.

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