Re: Locally managed tablespaces and migrated rows

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.

>