Guido,

> A sweep can only be made by SYSDBA or the owner of the DB. Assume I

have

> a user USER1, who is not the DB owner. USER1 starts a transaction and
> the gap between OAT and OIT becomes greater than the sweep interval.

Is

> USER1 now allowed to run the automatic background sweep or not?

First, Sweep <> Garbage Collection

Second, a sweep will be automatically be initiated, by any user, if the
sweep internal condition has been met. If you don't want users to
initiate a sweep, set the interval to 0.

Running/initiating a sweep via GFix is considered a db maintenance task,
hence the specific access requirements.


Sean