UNIFORM extents

From: Michael Kline <mkline1_at_comcast.net>
Date: Mon, 19 Jul 2004 20:29:59 -0400
Message-ID: <IEEDIGCJJAPBLKMIGBPFOEPIKEAA.mkline1@comcast.net>

I was consolidating tablespaces today.
I would grab the dll from DBA Studio, then chop some of the "used to be  huge" tablespaces from 25 200mb files to perhaps 1 200Mb file with autoextend to 2gb or so which will probably not get used.

On several of these simply saying "extent management local uniform" defaulted now somehow to 10MB extents.

Where does this "default" come from?

Evidently when they were created, that default was 64k or so, now it's 10MB?

Michael Alan Kline, Sr.
Principal Consultant
Business to Business Solutions, LLC
Phone: 804-744-1545 Cell: 804-314-6262
ICQ: 1009605, 975313
Email: mkline_at_b2bsol.com Web: www.b2bsol.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Jul 19 2004 - 19:27:01 CDT