RE: strange temporary segment names

From: Bort, Guillermo <guillermo.bort_at_eds.com>
Date: Fri, 5 Dec 2008 05:25:52 -0600
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC00B3775F@usplm201.amer.corp.eds.com>

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_at_eds.com <mailto:name.name_at_eds.com>  

We deliver on our commitments

so you can deliver on yours.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LS Cheng Sent: Friday, December 05, 2008 9:23 AM
To: oracle-l_at_freelists.org
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  
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 05 2008 - 05:25:52 CST