RE: DROP LMT TBS internals.
- From: "Mohan, Ross" <RMohan@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 20 Sep 2004 17:44:29 -0400
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@xxxxxxxxx]
Sent: Monday, September 20, 2004 5:37 PM
To: rmohan@xxxxxxxxxxx
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@xxxxxxxxxxx> 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@xxxxxxxxxxx]
> Sent: Sunday, September 19, 2004 9:03 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxx 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@xxxxxxxxx
>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
