Re: Cancelling a long running query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 02 Nov 2005 09:04:44 +0100
Message-ID: <pmsgm1dpp5jbm3qp355rbj4u06lbvuuc49@4ax.com>

On Wed, 02 Nov 2005 12:22:16 +0530, amogh <amogh.r_at_gmail.com> wrote:

>Can someone please suggest me how I could write a query which executes
>continously (or recursively, to never return), using a table like EMP
>(or EMP joined with DEPT if necessary).
>

Take two big tables, join them, leaving out the join condition. This will result in a merge-join cartesian. Merge join-cartesians usually peg the CPU, and take forever.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Nov 02 2005 - 02:04:44 CST