strange temporary segment names
From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 5 Dec 2008 11:22:40 +0000
Message-ID: <6e9345580812050322l701cd92fvdaa12fba864fd9a3@mail.gmail.com>
Date: Fri, 5 Dec 2008 11:22:40 +0000
Message-ID: <6e9345580812050322l701cd92fvdaa12fba864fd9a3@mail.gmail.com>
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:22:40 CST