Re: strange temporary segment names
From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 5 Dec 2008 12:09:48 +0000
Message-ID: <6e9345580812050409x8d14f73i64e80f7ad01ceae8@mail.gmail.com>
Date: Fri, 5 Dec 2008 12:09:48 +0000
Message-ID: <6e9345580812050409x8d14f73i64e80f7ad01ceae8@mail.gmail.com>
Hello
It is a data tablespace.
Just bounced the RAC database but the temp segment entries are still there in dba_segments :-S
Thanks
-- LSC On Fri, Dec 5, 2008 at 11:25 AM, Bort, Guillermo <guillermo.bort_at_eds.com>wrote:Received on Fri Dec 05 2008 - 06:09:48 CST
> 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 <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