Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE ROLLBACK SEGMENT

Re: CREATE ROLLBACK SEGMENT

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 16 Nov 2000 19:47:21 -0000
Message-ID: <974400282.9858.0.nnrp-04.9e984b29@news.demon.co.uk>

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>...

>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.
>
>
Received on Thu Nov 16 2000 - 13:47:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US