Re: Locally managed tablespaces and migrated rows

Or pctincrease =0 on the tablespace ;-)

Jonathan Lewis wrote:

> I hope that was a rhetorical statement - I happen
> to think that LMTs are a 'good thing'. I just want
> to see Oracle take the next crucial step of making
> an official change to the clu$ cluster or to smon
> so that we don't get hit with smon kicking the
> dictionary to death every five minutes looking for
> space to coalesce. Have you seen what happens
> to I/O on the SYSTEM tablespace when your
> database has 25,000 tablespaces !!!
>
> (Unless you set events 10061 and 10269, or
> hack sql.bsq of course).
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
> Nuno Souto wrote in message <3af91311.4028559_at_news-server>...
> >
> >How true. And we have to live with them, they aren't gonna go away
> >just because we think they're rubbish.
> >
Received on Wed May 09 2001 - 12:01:56 CDT