Oracle's automatic extent allocation (next extent) size algorithm - anyone?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 30 Mar 2021 11:47:37 -0400
Message-ID: <CAP79kiQk7X_zmyVPM0S993sS1BP2kezuLEdk8RcHyzOgO6z+ew_at_mail.gmail.com>
Env: 12.1.0.2
Linux x86-64
Date: Tue, 30 Mar 2021 11:47:37 -0400
Message-ID: <CAP79kiQk7X_zmyVPM0S993sS1BP2kezuLEdk8RcHyzOgO6z+ew_at_mail.gmail.com>
Env: 12.1.0.2
Linux x86-64
For Oracle segments in Locally Managed Tablespaces with *AUTOMATIC* extent allocation (instead of UNIFORM extent allocation) , does anyone have the algorithm that Oracle uses to determine the next extent size that is based on the size of the segment?
I used to have it where it went something like:
IF segment > xG , then next extent = xGB IF Segment > xMB then next extent = xMB
I'm trying to find it but can't quickly locate it (because I'm not sure what keywords to search for)
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 30 2021 - 17:47:37 CEST