Re: ASM question

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: <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).