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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MINEXTENTS > 1 ?

RE: MINEXTENTS > 1 ?

From: <Winnie_Liu_at_infonet.com>
Date: Mon, 1 May 2000 15:26:50 -0700
Message-Id: <10484.104630@fatcity.com>


--0__=onY0tsG3XhLtKvSgqdNS0oMCNXLvN4DEJ5wneqZkPenHeNY2bvgGqGq1
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Alex,

Thanks. It makes a lot more sense to make use of the minextents now.

Winnie

Alex Hillman <alex_hillman_at_physia.com> on 05/01/2000 03:40:45 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: RE: MINEXTENTS > 1 ?

When Oracle allocate extents during table if tablespace has several files it
creates extents using round robin in tablespace files - and if these files are on different devices we can achieve distribution of IO.

Alex Hillman

-----Original Message-----

Sent: Monday, May 01, 2000 5:15 PM
To: Multiple recipients of list ORACLE-L

Umm.. then I have another question, why don't we use ALTER TABLE .. ALLOCATE EXTENT to increase the number of extents of the table to whatever number you wish before you import the table.

Why do we want to use the parameter minextent instead?

Winnie

"Thapliyal, Deepak" <DThapliyal_at_ea.com> on 05/01/2000 12:47:31 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

lets assume that you have a dw table which u expect to grow in gigs .. you would probabaly use more then 1 ext to start with for suh tables so that it has a big size to begin with ..

-----Original Message-----

Sent: Monday, May 01, 2000 11:56 AM
To: Multiple recipients of list ORACLE-L

When would you want to set MINEXTENTS to something other than '1' for a table? The only case I can think of is if I am trying to manually stripe a table/tablespace across multiple disks.

Thanks.
-w

--0__=onY0tsG3XhLtKvSgqdNS0oMCNXLvN4DEJ5wneqZkPenHeNY2bvgGqGq1
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjQ0OC4wIj4NCjxUSVRMRT5SRTogTUlO RVhURU5UUyAmZ3Q7IDEgPzwvVElUTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCg0KPFA+PEZPTlQgU0la RT0yPldoZW4gT3JhY2xlIGFsbG9jYXRlIGV4dGVudHMgZHVyaW5nIHRhYmxlIGlmIHRhYmxlc3Bh Y2UgaGFzIHNldmVyYWwgZmlsZXMgaXQgY3JlYXRlcyBleHRlbnRzIHVzaW5nIHJvdW5kIHJvYmlu IGluIHRhYmxlc3BhY2UgZmlsZXMgLSBhbmQgaWYgdGhlc2UgZmlsZXMgYXJlIG9uIGRpZmZlcmVu dCBkZXZpY2VzIHdlIGNhbiBhY2hpZXZlIGRpc3RyaWJ1dGlvbiBvZiBJTy48L0ZPTlQ+PC9QPg0K DQo8UD48Rk9OVCBTSVpFPTI+QWxleCBIaWxsbWFuPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBT SVpFPTI+LS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y PkZyb206IFdpbm5pZV9MaXVAaW5mb25ldC5jb20gWzxBIEhSRUY9Im1haWx0bzpXaW5uaWVfTGl1 QGluZm9uZXQuY29tIj5tYWlsdG86V2lubmllX0xpdUBpbmZvbmV0LmNvbTwvQT5dPC9GT05UPg0K PEJSPjxGT05UIFNJWkU9Mj5TZW50OiBNb25kYXksIE1heSAwMSwgMjAwMCA1OjE1IFBNPC9GT05U Pg0KPEJSPjxGT05UIFNJWkU9Mj5UbzogTXVsdGlwbGUgcmVjaXBpZW50cyBvZiBsaXN0IE9SQUNM RS1MPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5TdWJqZWN0OiBSRTogTUlORVhURU5UUyAmZ3Q7 IDEgPzwvRk9OVD4NCjwvUD4NCjxCUj4NCjxCUj4NCg0KPFA+PEZPTlQgU0laRT0yPlVtbS4uIHRo ZW4gSSBoYXZlIGFub3RoZXIgcXVlc3Rpb24sIHdoeSBkb24ndCB3ZSB1c2UgQUxURVIgVEFCTEUg Li48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPkFMTE9DQVRFIEVYVEVOVCB0byBpbmNyZWFzZSB0 aGUgbnVtYmVyIG9mIGV4dGVudHMgb2YgdGhlIHRhYmxlIHRvIHdoYXRldmVyPC9GT05UPg0KPEJS PjxGT05UIFNJWkU9Mj5udW1iZXIgeW91IHdpc2ggYmVmb3JlIHlvdSBpbXBvcnQgdGhlIHRhYmxl LjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPldoeSBkbyB3ZSB3YW50IHRvIHVzZSB0 aGUgcGFyYW1ldGVyIG1pbmV4dGVudCBpbnN0ZWFkPzwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQg U0laRT0yPldpbm5pZTwvRk9OVD4NCjwvUD4NCjxCUj4NCjxCUj4NCjxCUj4NCjxCUj4NCg0KPFA+ PEZPTlQgU0laRT0yPiZxdW90O1RoYXBsaXlhbCwgRGVlcGFrJnF1b3Q7ICZsdDtEVGhhcGxpeWFs QGVhLmNvbSZndDsgb24gMDUvMDEvMjAwMCAxMjo0NzozMSBQTTwvRk9OVD4NCjwvUD4NCg0KPFA+ PEZPTlQgU0laRT0yPlBsZWFzZSByZXNwb25kIHRvIE9SQUNMRS1MQGZhdGNpdHkuY29tPC9GT05U Pg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+VG86Jm5ic3A7Jm5ic3A7IE11bHRpcGxlIHJlY2lw aWVudHMgb2YgbGlzdCBPUkFDTEUtTCAmbHQ7T1JBQ0xFLUxAZmF0Y2l0eS5jb20mZ3Q7PC9GT05U Pg0KPEJSPjxGT05UIFNJWkU9Mj5jYzombmJzcDsmbmJzcDsmbmJzcDsgKGJjYzogV2lubmllIExp dS9IUS9JU0MpPC9GT05UPg0KPC9QPg0KPEJSPg0KPEJSPg0KPEJSPg0KPEJSPg0KDQo8UD48Rk9O VCBTSVpFPTI+bGV0cyBhc3N1bWUgdGhhdCB5b3UgaGF2ZSBhIGR3IHRhYmxlIHdoaWNoIHUgZXhw ZWN0IHRvIGdyb3cgaW4gZ2lncyAuLiB5b3U8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPndvdWxk IHByb2JhYmFseSB1c2UgbW9yZSB0aGVuIDEgZXh0IHRvIHN0YXJ0IHdpdGggZm9yIHN1aCB0YWJs ZXMgc28gdGhhdCBpdDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+aGFzIGEgYmlnIHNpemUgdG8g YmVnaW4gd2l0aCAuLjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPi0tLS0tT3JpZ2lu YWwgTWVzc2FnZS0tLS0tPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5TZW50OiBNb25kYXksIE1h eSAwMSwgMjAwMCAxMTo1NiBBTTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+VG86IE11bHRpcGxl IHJlY2lwaWVudHMgb2YgbGlzdCBPUkFDTEUtTDwvRk9OVD4NCjwvUD4NCjxCUj4NCg0KPFA+PEZP TlQgU0laRT0yPldoZW4gd291bGQgeW91IHdhbnQgdG8gc2V0IE1JTkVYVEVOVFMgdG8gc29tZXRo aW5nIG90aGVyIHRoYW4gJzEnIGZvciBhPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj50YWJsZT8g VGhlIG9ubHkgY2FzZSBJIGNhbiB0aGluayBvZiBpcyBpZiBJIGFtIHRyeWluZyB0byBtYW51YWxs eSBzdHJpcGUgYTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+dGFibGUvdGFibGVzcGFjZSBhY3Jv c3MgbXVsdGlwbGUgZGlza3MuPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+VGhhbmtz LjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+LXc8L0ZPTlQ+DQo8L1A+DQo8QlI+DQoNCjwvQk9E Received on Mon May 01 2000 - 17:26:50 CDT

Original text of this message

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