Re: How to tune SQL to avoid ORA-03232 ?

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 16 Oct 2002 13:24:22 +0200
Message-ID: <aojifn$n3rr9$1@ID-152732.news.dfncis.de>

...
> I always run delete plan_table before an explain plan.

Hi, Niall, that is just the strange thing that I observe now: PLAN_TABLE contains just 50 rows
(but when I see the weird plan it lists an incredible bunch of text)

but DELETE FROM PLAN_TABLE takes forever ... TRUNCATE TABLE is impossible (ORA-00054), I cant even drop it.
What is going on here ...

Has anybody observed such a strange thing before ? I never did...

Yours, Jan

>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Wed Oct 16 2002 - 06:24:22 CDT