Re: strange temporary segment names
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- Date: Fri, 5 Dec 2008 12:09:48 +0000
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@xxxxxxx>wrote:
> 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 <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
>
>
>
Other related posts:
