Database Administration (MOSC)

MOSC Banner

Why a remote query (through Oracle net) can block a rollback segment on the remote database ?

edited Dec 2, 2008 9:10PM in Database Administration (MOSC) 2 commentsAnswered
 Hello,

I wonder why a remote query (through Oracle net) can block a rollback segment on the remote database. Indeed, a rollback segment is used when a transaction perform some data uptades, to save the old values (before update). But a remote query doesn't change any data, so why using a rollback segment ?

Thanks for your help,

G. Delferrière

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