Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Locally managed tablespaces and migrated rows

Re: Locally managed tablespaces and migrated rows

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 10 May 2001 00:18:45 +1000
Message-ID: <3af951c9@news.iprimus.com.au>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:989404894.15128.0.nnrp-10.9e984b29_at_news.demon.co.uk...
>
> 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 !!!

Jonathan, I am desperate.... I need that script!! I *want* 25,000 tablespaces, but I'm buggered if I'm going to sit there typing the usual SQL out 25,000 times (besides, I get confused with my file names after the third one). Email me, PLEASE!!!!

(Just joking, though I've finally come up with a script that will insert a million rows into emp, which makes me happy. God what a sad life I lead!)

>
> (Unless you set events 10061 and 10269, or
> hack sql.bsq of course).
>

Of course.

Of course???!

Cheers, Jonathan!
HJR
>
>
>
> --
> 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 - 09:18:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US