Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: index node split autonomy
<ctcgag_at_hotmail.com> wrote in message
news:20030525191450.694$U2_at_newsreader.com...
> Many of the concurrency/consistency concepts are demonstrated in the
Oracle
> docs with simple examples on tables, where the process has to reach into
> the undo to obtain a read-consistent view. I think I more or less
> understand this. But I'm curious about the analogous operations on
> indices. If indices never split blocks, it seems they could operate in
> pretty much the same way as tables. But then they wouldn't be much good
as
> indices, either.
>
> If an DML statement causes a index block to split, and then
> that statement rolls back, is the split also rolled back, or does
> it persist?
>
>
> Xho
>
> --
> -------------------- http://NewsReader.Com/ --------------------
> Usenet Newsgroup Service New Rate! $9.95/Month 50GB
Xho,
How can the split be rolled back? Others may have inserted entries. You don't take an exclusive lock on an index to insert one row into a table. This is a 'long trousers' database.
Regards,
Paul
Received on Mon May 26 2003 - 13:39:42 CDT