Database Tuning (MOSC)

MOSC Banner

understand locking for SQl LOADER

edited Jul 8, 2009 2:46AM in Database Tuning (MOSC) 1 commentAnswered
Hi All,

I am trying to understand locking scenario when invoking sql loader both convention and direct load method.

direct load

Can two direct load run concurrent on same table? is it exclusive lock which took place on table? Can other users run simple select queries when direct load is executing?

Conventional load

Can two conventional load run concurrently on same table? what kind of lock took place here? can other users run simple select queries when conventiional load is executing? Can update statement execute on diffrent set of rows when conventional load  is executing on same table?

Thanks

newbee

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