Extent number

Posted in 2003

Topics: Performance & Tuning, Storage & Space Management

FRANKLIN TANG — Mon, 27 Jan 2003 09:31:10 — source: IIUG Forums & Mailing Lists

Hi all, I have a couple of tables with 20 extents, does it hurt the performance of my database if i need to search those tables very often??? I read an article that extent number for a table should be kept 8 or below, is that ture??? What can i do?? drop the table with a bigger extent size?? is this the only way to do it??? Thanks Franklin

↪ replying to FRANKLIN TANG

Schuran, Sven — Mon, 27 Jan 2003 10:39:09 — source: IIUG Forums & Mailing Lists

hi, I think 20 extents might be ok, but please calculate what size your table might have in a few weaks, month. So check and change the next extent size for these tables. If you like to put these extent together, unload table, drop table, create table, load table with correct first and next extent sizes. The better way is, unload whole database, drop dbspaces, create dbspaces, create database, check next extent size of system tables, load database with correct first and next extent sizes. cu sven -----Ursprüngliche Nachricht----- Von: FRANKLIN TANG [mailto:franklin@macauslot.com] Gesendet: Montag, 27. Januar 2003 10:31 An: ids@iiug.org Betreff: Extent number [118] Hi all, I have a couple of tables with 20 extents, does it hurt the performance of my database if i need to search those tables very often??? I read an article that extent number for a table should be kept 8 or below, is that ture??? What can i do?? drop the table with a bigger extent size?? is this the only way to do it??? Thanks Franklin

↪ replying to Schuran, Sven

Obnoxio The Clown — Mon, 27 Jan 2003 12:27:14 — source: IIUG Forums & Mailing Lists

Or use ALTER FRAGMENT ... INIT IN ... -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche >From: "Schuran, Sven" <sschuran@maske.de> >To: ids@iiug.org >Subject: AW: Extent number [120] Date: Mon, 27 Jan 2003 05:39:09 -0500 >(EST) > >hi, > >I think 20 extents might be ok, but please calculate what size your table >might have in a few weaks, month. >So check and change the next extent size for these tables. >If you like to put these extent together, unload table, drop table, create >table, load table with correct first and next extent sizes. > >The better way is, unload whole database, drop dbspaces, create dbspaces, >create database, check next extent size of system tables, load database >with correct first and next extent sizes. > >cu sven > >-----Ursprüngliche Nachricht----- >Von: FRANKLIN TANG [mailto:franklin@macauslot.com] >Gesendet: Montag, 27. Januar 2003 10:31 >An: ids@iiug.org >Betreff: Extent number [118] > > >Hi all, > I have a couple of tables with 20 extents, does it hurt the >performance of my database if i need to search those tables very often??? I >read an article that extent number for a table should be kept 8 or below, >is that ture??? What can i do?? drop the table with a bigger extent size?? >is this the only way to do it??? > > >Thanks > >Franklin _________________________________________________________________ Chat online in real time with MSN Messenger http://messenger.msn.co.uk

↪ replying to FRANKLIN TANG

Madison Pruet — Mon, 27 Jan 2003 16:43:53 — source: IIUG Forums & Mailing Lists

The 8 extent issue is with 5.x only. M.P. "FRANKLIN TANG" <franklin@macausl To: ids@iiug.org ot.com> cc: Sent by: Subject: Extent number [118] forum.subscriber@ iiug.org 01/27/2003 03:31 AM Hi all, I have a couple of tables with 20 extents, does it hurt the performance of my database if i need to search those tables very often??? I read an article that extent number for a table should be kept 8 or below, is that ture??? What can i do?? drop the table with a bigger extent size?? is this the only way to do it??? Thanks Franklin