hmmm... odd there is no setting for pct_used on tables, but different settings for percent free. Different settings for initial extent to between tables.
anyone have more info on how this 'intelligent' algorithm works? I heard kyte speak last week and he assured us that the algorithm is good and there is only 'irrelevant' fragmentation. I dont want to use it in production until I understand it better. > > From: <[EMAIL PROTECTED]> > Date: 2003/12/22 Mon AM 09:09:26 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: ASM question > > I decided to play around with ASMs and use the statspack tablespace as my trial > balloons(lots of inserts and deletes and I dont care about fragmentation). > > anyway I just ran SPCREATE. Wierd thing is that there is no data in any of my > statspack tables, but their segments sizes vary from 1m to 5m??? > > any idea why? There has never been any data inserted in them. I just created the > tablespace and ran spcreate? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).