Rare huge surge in TEMP space usage
From: Frank Gordon <frankagordon_at_gmail.com>
Date: Thu, 6 Dec 2018 10:05:16 +0000
Message-ID: <CAA0QMtk=fk4FHnzXM9fx+m1TCveX3=BNhTyZ8xDbki+NKoUeDg_at_mail.gmail.com>
Hello,
Date: Thu, 6 Dec 2018 10:05:16 +0000
Message-ID: <CAA0QMtk=fk4FHnzXM9fx+m1TCveX3=BNhTyZ8xDbki+NKoUeDg_at_mail.gmail.com>
Hello,
WITH t AS (select ... from tables WHERE ... group by everything),
u AS (select ... from T, table WHERE ..) SELECT ... FROM tables, T, U
Anyone ever seen anything like this before?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 06 2018 - 11:05:16 CET