RE: strange temporary segment names

From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>

To: <exriscer@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>

Date: Fri, 5 Dec 2008 05:25:52 -0600

What kind of tablespace is TBS_DON_DATA? If it's not the default
temporary tablespace (or part of the temp tbs group) I'd find it rather
weird to have SYS' objects in there... even If they are temporary
segments. Have you tried recycling the instances? It would clean the
temp tbs and those segments should go away.
hth
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
ITO
Arias 1851
Ciudad Autonoma de Buenos Aires (C1429DXC)
Argentina
Tel: +54 11 4704-3132
E-mail: guillermo.bort@xxxxxxx <mailto:name.name@xxxxxxx>
We deliver on our commitments
so you can deliver on yours.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of LS Cheng
Sent: Friday, December 05, 2008 9:23 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: strange temporary segment names
Hello
I have a database with some strange temporary segments under SYS schema
seen from dba_segments as follows:
OWNER SEGMENT_TYPE SEGMENT_NAME
TABLESPACE_NAME
------------------------------ ------------------
------------------------------ ------------------------------
SYS TEMPORARY 84.41971
TBS_DON_DATA
SYS TEMPORARY 84.13427
TBS_DON_DATA
SYS TEMPORARY 84.12659
TBS_DON_DATA
I remember see these sort of names when a index is being rebuilt but
this is not the case. They are constantly there.
This happened after transporting 3TB Tablespaces from a 10g database
running on Solaris to a 2 Nodes Linux x86-64 RAC running in 11g.
any clues?
Thanks
--
LSC