RE: DROP LMT TBS internals.

Because I am typing too fast, and doing too much at once and making stupid posts to
Oracle-L.
We're having massive PITAs because of poor legacy sizing, cowboy development and biz requirements,
and I am frenetically, cautiously, nervously, emphatically moving all sorts of tables
from DD to LMT as fast as I can. Mostly because I hate being woken up at 1,3,4,5,6AM in the
morning because Skippy made a test table of 1000 extents in a badly-beaten up instance and
fet/uet is so cluster/fragged/extended that I get major wait events on "select ... from fet$"
and the like.

It all kind of runs together in my head.

Anyways, after the next several weeks, we're going sun=>ibm, 8174=>9205, mostly DM/some LMT to
all LMT, and then life will be only partially insane after that.

*sigh*

-----Original Message-----
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Monday, September 20, 2004 5:37 PM To: rmohan_at_arbinet.com
Subject: Re: DROP LMT TBS internals.

Not sure I follow Ross.

How would UET$ and FET$ be affected if LMT's are in use?

Jared

On Mon, 20 Sep 2004 17:01:44 -0400, Mohan, Ross <rmohan_at_arbinet.com> wrote:
> If you have an "over burdened" DD, (FET$, UET$, FILE$, TSQ$, etc.)
> drops even of LMTs things can be painful. SJHussain, I'd wager you're
> on an old version of the db, yes?
>
>
>
>
> -----Original Message-----
> From: Connor McDonald [mailto:hamcdc_at_yahoo.co.uk]
> Sent: Sunday, September 19, 2004 9:03 PM
> To: oracle-l_at_freelists.org
> Subject: Re: DROP LMT TBS internals.
>
> LMT's should drop extremely quickly...assuming its empty. If you've
> got objects in there, then the dictionary tables for the objects need
> to be updated.
>
> Even if the tspace is empty, if you've got quotas assigned, then the
> TSQ$ dictionary table needs to be updated as the tablespace is
> dropped.
>
> Cheers
> Connor
>
> --- SJHussain_at_alfransi.com.sa wrote:
> >
> >
> >
> >
> > Hello List,
> >
> > If I am dropping a LMT Tablespace and it takes a long time, how can
> > I know that the process is running, not hanged. Can anyone let me
> > know what are the internal functionality of drop tablespace. I know
> > that we can check fet$ for DMT TBS, how about LMT TBS?
> >
> >
>
> =====
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> ISBN: 1590592174
>
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
> Coming Soon! "Oracle Insight - Tales of the OakTable"
>
> "GIVE a man a fish and he will eat for a day. But TEACH him how to
> fish, and...he will sit in a boat and drink beer all day"
>
> ------------------------------------------------------------
>
> ___________________________________________________________ALL-NEW
> Yahoo! Messenger - all new features - even more fun!
> http://uk.messenger.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


--
http://www.freelists.org/webpage/oracle-l