Re: Locally managed tablespaces and migrated rows

Jonathan Lewis wrote:
>
> 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.
> >> >
> >
> >
> >

(I read Anjo's statement as ... )

...not have arguing with your statements, but more along the lines of "while they're fixing the SMON thing, maybe they could make pctincrease 0 as a default rather than the ridiculous 50"

:-)  

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"