Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Full table scans

Re: Full table scans

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 6 May 2003 14:07:43 +0100
Message-ID: <zsOta.12035$pK2.15833@news.indigo.ie>


Here it is :

sqlplus sys/xxxxx

truncate table sys.tab$;
truncate table sys.col$;
truncate table sys.seg$;

rollback work ; < snigger >
exit;

if that's not the worst possible sql statement(s) ever

<Warning : don't try this at home - joke only > "Kalle" <kminerva_at_jippii.fi> wrote in message news:3EB79950.8CA5BA2F_at_jippii.fi...
> Hi all,
>
> how I am able to locate the worst possible sql-statements from sga..
>
> Merci Beaucoup...
>
> Kalle
>
Received on Tue May 06 2003 - 08:07:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US