Re: SYS-Objects in temporary Tablespace

See the FAQ noted below - in particular the DBA article:

    My temporary tablespace never clears down, what should I do ?

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

waltervdv wrote in message ...


>Hallo !

>

>This morning our production went onto following Error:

>

>ORA-01652: unable to extend temp segment by  in tablespace

>

>The size of our temporary tablespace was 400 MB and I extended it to

>500 MB.

>The error occured while a huge select-statement was executed. After

>resizing the tablespace, the error didn't occure again.

>

>When I looked at the content of the temporary tablespace I found one

>big temporary object owned by SYS (name = "3.9986", size 399,5 MB).

>This object remains. It keeps 90 % of the temporary tablespace.

>

>

>Is the space used by this object lost or is it internally used for

>sorting, ... ???

>What is the purpose of this object ?

>

>

>Thank You for any information !

>

>Marcus