Re: Rollback segments
Date: 15 Jan 92 02:40:57 GMT
Message-ID: <mark.695443257_at_snark>
>We are running ORACLE version 6.0.32 on a SUN workstation
>and are having problems with rollback segments not having
>enough extents. The manual says to increase maxexents and
>try again but then says in the explanation of storage parameters
>that maxextents is OS and block size dependent.
>Does anyone have any info on how to find more info on max
>extents for my environment?
>Thanks!
>Marianne Brooks
>ARCO Exploration and Production Technology
>marianne.brooks_at_Edm.Arco.COM
>214-754-4295
The default maximum number of extents for any object on the sun-4 platform is 121. The following is from the Installation and User Guide for 6.0.30; page 2-29:
Maximum block size maxextents value ------------------ ---------------- 512 bytes 25 1k 57 2k 121 4k 249 8k 505
The only way to increase the maxextents is to change the block size, which requires a full export/import.
Mark Hessling Email: mark_at_snark.itc.gu.edu.au ITC Phone: +617 875 7691 Griffith University Fax: +617 875 7877Nathan, Brisbane QLD 4111 Australia
Received on Wed Jan 15 1992 - 03:40:57 CET