RE: avoiding ora-1652 on temp tablespace

Scott -

There are hundreds of queries, I know I haven't even seen them all. I tried tracing on our test instance, 5m filled up in about 10 minutes. This is another application that doesn't use bind variables....

You're right, something ugly is going on!

Linda

-----Original Message-----
[mailto:Scott.Shafer_at_dcpds.cpms.osd.mil] Sent: Thursday, April 05, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L

Start running explain plan for your queries. Sounds like you have a cartesian product somewhere in the code...

Scott Shafer
San Antonio, TX
210-581-6217

> -----Original Message-----
> From: Seley, Linda [SMTP:LSeley_at_IQNavigator.com]
> Sent: Thursday, April 05, 2001 12:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: avoiding ora-1652 on temp tablespace
>
> We recently released a new version of our software and suddenly we're
> blowing out our temp tablespace. The previous version never complained at
> 1000m. The new version is choking on 2500m. I don't want to keep adding
> space, although that's the conventional wisdom. I want to find the query
> or queries that are being pigs and get the developers to fix 'em!
>
> By the time I get notification that there's been an ora-1652 I can't find
> much info in the system. All of the currently running queries are small,
> we only have 20 users connected at any time, v$sort_usage is empty, and
> v$sort_segment shows one segment taking the full 2500m. I also can't turn
> on tracing, these 20 users are persistent and trace files will fill up in
> no time. Our entire database is VERY small, only about 60m!
>
> Any advice on how to catch these queries? The ora-1652 errors are
> occuring about a week apart so it isn't practical for me to personally
> babysit the database.
>
> Thanks!
>
> Linda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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: Seley, Linda
  INET: LSeley_at_IQNavigator.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).