ignore spcreate.sql actually puts pctfree,pctused, and really bad initial and next extent settings on the tables. its an antiquated script that hasnt been updated.
my bad.
>
> From: <ryan_oracle_at_cox.net>
> Date: 2003/12/22 Mon AM 09:09:26 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: <ryan_oracle_at_cox.net
> INET: ryan_oracle_at_cox.net
>
> 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: ListGuru_at_fatcity.com (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: <ryan_oracle_at_cox.net
INET: ryan_oracle_at_cox.net
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: ListGuru_at_fatcity.com (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).
Received on Mon Dec 22 2003 - 08:24:32 CST
