Re: SQL without end

romanhodain_at_email.cz wrote:
> Hi,
> sorry my hold up.
> Operational system: Windows-server 2003 and SUSE 10.2
> Oracle db: Oracle 10g - 10.2.0.1.0
> Hardware: CPU: 2 x Intel Core2 CPU 6400_at_2.13GHz
> MEM: 4GB
>
> I try to rewrite SQL but the problem not in specific join. Problem is
> realy in quantity JOINs. This sql is generated from SQL generator from
> java aplication. I can't change SQL. This SQL running about 6 days. I
> have enable SQL trace but anything is generated. Only in enterprice
> manager I see db file sequential read on system Tablespace.
>
> Roman Hodain
>

<snip>

Please don't top-post. (Put your reply at the BOTTOM, not the TOP, or embed individual comments immediately after the relevent comment to which you are replying).

You say the OS is "Windows-server 2003 and SUSE 10.2". So which is it?  The specific problem can ever only be on one at a time.

4gb of memory, with a query like that? I'm beginning to suspect the server could be paging itself to death. Have you tried captureing a statspack report while this problem query is running? If running Windows, have you looked at what perfmon is saying about things? Received on Tue Jan 23 2007 - 09:15:06 CST