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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: streams comments

Re: streams comments

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Wed, 13 Aug 2003 10:29:32 -0800
Message-ID: <F001.005CA81B.20030813102932@fatcity.com>


Stephen,

Did you write all the parameters by hand or used a script? ;)

> "analyze table ...." have "exec

DBMS_STATS.ONE_OF_273_POSSIBLE_CALLS(arg1,
> arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9, arg10, arg11, arg12,
arg13,
> arg14, arg15, arg16, arg17, arg18, arg19, arg20, arg21, arg22, arg23,
arg24,
> arg25, arg26, arg27, arg28, arg29, arg30, arg31, arg32, arg33, arg34,
arg35,
> arg36, arg37, arg38, arg39, arg40, arg41, arg42, arg43, arg44, arg45,
arg46,
> arg47, arg48, arg49, arg50, arg51, arg52, arg53, arg54, arg55, arg56,
arg57,
> arg58, arg59, arg60, arg61, arg62, arg63, arg64, arg65, arg66, arg67,
arg68,
> arg69, arg70, arg71, arg72, arg73, arg74, arg75, arg76, arg77, arg78,
arg79,
> arg80, arg81, arg82, arg83, arg84, arg85, arg86, arg87, arg88, arg89,
arg90,
> arg91, arg92, arg93, arg94, arg95, arg96, arg97, arg98, arg99, arg100)".
>
> Do you get the impression that Oracle is just too damn lazy to update
their
> syntax parser?

I don't see anything wrong with it - I thank god (every night) that Oracle has so many features and controls and hasn't hidden them away from us. If you want to do things easy - use OEM and get SQL & PL/SQL execution commands from it using "Show SQL".

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 13 2003 - 13:29:32 CDT

Original text of this message

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