Re: create index and rollback segs?

Each DDL statement starts and ends with an implicit commit.

It would be interesting to hear the final comment on this one - rollback due to
recursive transactions should go into
the SYSTEM tablespace anyway, so
a trace may not help.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Lothar Armbüster wrote in message
<1276.12T2683T11235506_at_rheingau.netsurf.de>...
>Jonathan Lewis wrote at 08-Dez-99 20:44:42
>>Bear in mind though that 'create index'
>>starts with an implicit commit, which immediately
>>undoes the effect of your 'set transaction'.
>
>Really? I always thought 'create index' *ends* with a commit.
>Anyway creating an index does not have anything to rollback so there
>should not be any use of rollback segments.

>
>We now followed the advice of Oracle Support to take all rbs except the
>big one and system offline. Then the create index succeeded.
>Maybe when there is some spare time, I will rerun the create index with
>sql_trace enabled to see what recursive SQL produces that much rollback.
Received on Thu Dec 09 1999 - 12:34:19 CST