Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE ROLLBACK SEGMENT
It's not all that complicated, and a trivial test shows that even in 8.1 it's possible to create extents of less than 5 blocks.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison Wesley Longman Book bound date: 8th Dec 2000 See a first review at: http://www.ixora.com.au/resources/index.htm#practical_8i Alex Filonov wrote in message <8v170v$mq2$1_at_nnrp1.deja.com>...Received on Thu Nov 16 2000 - 13:47:21 CST
>Actually minimum extent size is 5 blocks. Oracle can also increase it if
>it feels like it, it became pretty complex in 8.1. Anyway, it's funny
>to see initial, next and optimal sizes in K. Usually rollback segment is
>measured in megabytes.
>
>