Re: TEMP Tablespace Question
Date: Sun, 26 Oct 2003 14:01:30 +0100
Message-ID: <bnggjd$m9e$1_at_news4.tilbu1.nb.home.nl>
Paul,
This is a golden oldie in Oracle - just do a Google search. As I understand it as a developer, it is not unusual for TEMP to be running at 99% usage, since the space is usually reclaimed on demand or through a process that wakes up every hour or so.
Given the circumstance that it only happens in one app, I expect it to be a
suboptimal query that is doing a superfluous join/sort whatever. It happened
to me once too:
Me: "My program sometimes crashes with ORA-01652 ".
DBA: "There's something wrong with your program".
Me (arrogantly): "Writing optimal and correct Oracle SQL queries has become
second nature to me".
DBA: "There's still something wrong with your program".
Me (after some research, shamefaced): "I found a non-optimal query in my
program that caused a Cartesian join".
Just use a tool like PL/SQL Developer or TOAD or one of the others to easily explain plan your queries.
Regards,
Frans
Received on Sun Oct 26 2003 - 14:01:30 CET