help: local managed tablespace, next extent
From: <dshproperty_at_gmail.com>
Date: Mon, 23 Sep 2013 13:02:46 -0700 (PDT)
Message-ID: <8e2604e3-1e1f-40e6-9e6f-0d0f2d7f3f96_at_googlegroups.com>
Dear group,
Date: Mon, 23 Sep 2013 13:02:46 -0700 (PDT)
Message-ID: <8e2604e3-1e1f-40e6-9e6f-0d0f2d7f3f96_at_googlegroups.com>
Dear group,
I have a tablespace which is 300G and devided into 15 datafiles.
The tablespace is local managed.
But recently when it expends, it took 14G of free space.
How does Oracle decide next extent when it comes to datafile expansion? is this adjustable?
Thanks for your help
Charlie Received on Mon Sep 23 2013 - 22:02:46 CEST