Re: Looking for a Script to list tables,its indexes and sizing info

Or maybe ASM?

As I recall, dynamically resolving "hot spots" is part of the propaganda -- er, I mean announced features -- of ASM. I haven't been daring enough to actually *try* ASM yet, so I rely mostly on rumour and -- when motivated enough -- documentation. Does anybody have any experiences they care to share? With regard to ASM and I/O balancing, that is...

The major downside to SAME is that (with some RAID technologies, anyway) adding capacity can still be painful. Of course, if you don't approach the idea literally, that pain /can/ be limited.

Jared Still wrote:

> On 1/27/06, *BN* <bnsarma_at_gmail.com <mailto:bnsarma_at_gmail.com>> wrote:
>
> Greetings,
>
> This is not a Home work Question, I am trying to group tables
> based on their activty(high dml, hihg read, etc.,) and put them in
> New LMTS tablespaces with proper sizes and settings yo avoid hot
> disk issues.
>
>
>
> Looks like a good reason to use SAME (stripe and mirror everything)
>
> No hot spots. Less work.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l