| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT (kinda) RE: DROP LMT TBS internals.
All this is, is a spam filter that someone at thump_at_cosmiccooler.org
is running. It's determined that the mail you sent "might" be spam.
So, it automatically sends the reply below, saying "Please verify you're
a real person, and not a spam bot". This isn't a virus, trojan, or =
anything
to be feared. Your mail will sit in quarantine for some preconfigured=20
amount of time, say, 1 week or 2 weeks. If, before the quarantine =
expires,
you reply to that mail, then your original mail will be marked as NOT =
SPAM,
and delivered to thump_at_cosmiccooler.org. If you choose to not reply to =
this
mail, then the original mail you sent will automatically be deleted, and =
the
recipient will never see it. Generally, if you reply to one of these =
one time,
your email address will be whitelisted, and you'll never need to reply =
to one=20
again.
I've been meaning to set one of these up myself (I get a LOT of spam), =
but I've
never gotten around to it.
Hope that helps clarify what was going on,
-Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mohan, Ross
Sent: Tuesday, September 21, 2004 1:01 PM
To: oracle-l_at_freelists.org
Subject: OT (kinda) RE: DROP LMT TBS internals.
I got this intercept?/virus?/trojan? in my email just after=20
sending the below post to the list.=20
It may be my-site-specific, but...in case it isn't...i include
it here FYI.
####################################################################
The message you sent requires that you verify that you=20 are a real live human being and not a spam source.
To complete this verification, simply reply to this message and leave =
the
subject line intact.
The headers of the message sent from your address are show below:
>From oracle-l-bounce_at_freelists.org Tue Sep 21 11:36:49 2004
Received: from [206.53.239.180] (helo=3Dturing.freelists.org)
by amber.monochrome.net with esmtp (Exim 4.34) id 1C9ndJ-0001Dq-CU for thump_at_cosmiccooler.org Tue, 21 Sep 2004 11:36:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B8F0772C7DF; Tue, 21 Sep 2004 11:36:45 -0500 (EST)Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP = id
by turing.freelists.org (Avenir Technologies Mail Multiplex) with
ESMTP
id F09BF72C808; Tue, 21 Sep 2004 11:36:44 -0500 (EST)
Message-ID:
<CC74E7E10A8A054798B6611BD1FEF4D30625D32B_at_vamail01.thexchange.com>
From: "Mohan, Ross" <RMohan_at_arbinet.com>
Subject: RE: DROP LMT TBS internals.
Date: Tue, 21 Sep 2004 12:35:53 -0400
MIME-Version: 1.0
Content-type: text/plain
To: <oracle-l_at_freelists.org>
X-Spam-Details: Hits=3D-4.8, Required=3D2, Tests=3DBAYES_00,HTML_MESSAGE X-Scanned-By: MIMEDefang 2.39 X-archive-position: 9850 X-ecartis-version: Ecartis v1.0.0
-----Original Message-----
From: Mohan, Ross [mailto:RMohan_at_arbinet.com]=20
Sent: Tuesday, September 21, 2004 12:36 PM
To: oracle-l_at_freelists.org
Subject: RE: DROP LMT TBS internals.
yea, I conflated a couple things creating confusion, but "yes", I had to
drop things with 150,000+ extents by doing truncate...reuse... and then
"alter...deallocate" judiciously. We used to have millions of used and =
free
extents, but now since=20
global=3D>partitioning conversion, have only about 140K total. Much=20
nicer, but...i think the damage has been done in C_TS# and =
C_FILE#_BLOCK#.=20
total PITA.=20
LMTs rock, totally. So looking forward to being on 92 on=20 real CPUs (non SPARC, whooppee!) and new DataDict...
-----Original Message-----
From: Mark W. Farnham [mailto:mwf_at_rsiz.com]=20
Sent: Tuesday, September 21, 2004 11:45 AM
To: oracle-l_at_freelists.org
Subject: RE: DROP LMT TBS internals.
oops. I didn't mean a Wolfgang (10053), I meant 10046.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Mark W. Farnham
Sent: Tuesday, September 21, 2004 9:37 AM
To: oracle-l_at_freelists.org
Subject: RE: DROP LMT TBS internals.
I'm not sure what would hold up dropping an LMT tablespace other than
dictionary operations on the names of the objects in the LMT. In the =
case of
LMTs, I'm not sure whether extra work is avoided by taking the =
tablespace
off-line and using offline drop including contents. That should, =
however,
short circuit transactions from interfering with the dictionary actions =
on
the objects in the tablespace, so if you offline the tablespace first =
and
then drop it you should be able to isolate where the wait is between
references to the segments in the tablespace and the mechanics of the =
drop
itself. I've never Wolfganged a drop tablespace (I did truss one long =
ago
but that was dictionary and before 10046 was available, and the output =
was
too long to analyze usefully.) I would think the operation in lieu of
segment reference interference would be so short that it wouldn't be =
worth
detailed research. Since you're having an actual problem, maybe it is
worthwhile.
Now if you really are looking for a metric on progress similar to =
watching
uet$ or fet$ for dictionary managed spaces, I suppose that if you count =
from
dba_segments where the storage is that tablespace you should see the =
count
drop. Of course that metric might slow down the operation.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of SJHussain_at_alfransi.com.sa
Sent: Sunday, September 19, 2004 3:21 AM
To: oracle-l_at_freelists.org
Subject: DROP LMT TBS internals.
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?
Best Regards,
Syed Jaffar Hussain
Visit us on www.alfransi.com.sa
=3D=3D=3D=3D=3D=3D Banque Saudi Fransi - Privacy Notice =
=3D=3D=3D=3D=3D=3D
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any =
use
of this information by persons or entities other than the intended =
recipient
is prohibited. If you have received this in error, please contact the
sender and delete the material from your computer. Any opinions and =
other
information contained in this message that do not relate to the =
official
business of Banque Saudi Fransi shall be understood as neither given =
or
endorsed by it. Although precautions have been taken to ensure no =
viruses
are present in this email, BSF cannot accept responsibility for any loss =
or
damage arising from the use of this email or attachments. =
=3D=3D=3D=3D=3D=3D Banque
Saudi Fransi - Privacy Notice =3D=3D=3D=3D=3D=3D
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 21 2004 - 12:12:13 CDT
 |
 |