Re: Locally managed tablespaces and migrated rows

Actually that doesn't help. SMON executes:  select
 f.file#, f.block#, f.ts#, f.length
 from fet$ f, ts$ t
 where t.ts#=f.ts#
 and t.dflextpct!=0

so it has to hit one block per tablespace (because that's the way the cluster is
defined) to determine whether the default pctincrease is zero.

--
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



Anjo Kolk wrote in message <3AF978E7.6B026837_at_chello.nl>...


>

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

>> >

>

>

>