Hi Group,

Sorry I know I've read a reasent discussion about diagnosing a full
temporary tablespace. But my mail account isn't cooperating. So if yoiu
please.

I have a schema which has a temporary table space. And a developer is
debugging a SQL query, (*with out a sort) which is filling the TS. I know
the solution is to just keep increasing the TS,

My question is How do I diagnosis the QUERY. I done a explain plan and all
looks OK? the resent changes to the query is 4 tables were added which are
thru a DBLink. Right now I'am tyaking the 4 DBL tables and creating a
view. If that does nothing, I'll create a temp table. Any suggestions
appreciated...

Sun Solaris 2.8, RDBMS 8.1.6.3 The tools developer is using is SQL
Navigator 3.

Thanks In Advance.

Burt Miller
Oracle LazyDBA home page