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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
