Re: Re:SYS Holding onto Temporary segments

Cool. What if TEMP is marked as a 'temporary' TS?

On Tue, 31 Oct 2000 05:40:54
 dgoulet wrote:
>Temporary segments in the temp area are always owned by sys. That is because
>the RDBMS kernel creates them for it's own purposes. What probably happen was
>some user who used the "three finger salute" on his/her PC & it just took PMON a
>little while to cleanup after them. An old trick to help alleviate that
>problem, try creating a table in the temp space that intentionally will not fit.
> The failed to create table_name statement will force PMON to wake up. In your
>case the second user did it for you.
>
>Dick Goulet
>
>____________________Reply Separator____________________
>Author: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>
>Date: 10/31/00 4:16 AM
>
>All,
>
>I had users complaining of select statements failing with "failed to extend
>temp segment" errors this morning. When I did a bit of digging around I
>noticed that SYS was holding onto 1 segment in the TEMP tablespace which was
>just under 15Gb (our temporary area almost full). I tried all the little
>tweaks (changing pctincrease to what it already was, coalescing etc) but to
>no avail, then about 5 minutes ago it released it all. Nobody was logged in
>as SYS.
>
>Is this a bug or is it my misunderstanding of how the temporary segments are
>used.
>
>TIA
>
>PS. Thanks to all who responded to my RAID query.
>
>
>Lee Robertson
>Acxiom
>Tel: 0191 525 7344
>Fax: 0191 525 7007
>Email: lerobe_at_acxiom.co.uk
>
>
>
>
>The information contained in this communication is
>confidential, is intended only for the use of the recipient
>named above, and may be legally privileged. If the reader
>of this message is not the intended recipient, you are
>hereby notified that any dissemination, distribution or
>copying of this communication is strictly prohibited.
>If you have received this communication in error, please
>re-send this communication to the sender and delete the
>original message or any copy of it from your computer
>system.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: dgoulet_at_vicr.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com Received on Tue Oct 31 2000 - 08:52:54 CST