hi all

there is one sql file

it has several inserts , updates, alter , create table,trigger,procedure statements.we have executed this sql by connecting to one schema.

now want to find out which Query is using what Rollback segment number while it is running ? which view will give me this answer?

there are 8 rollback segments.