I would recommend that you get a copy of O'Reilly's "Oracle Built-in Packages".
It's available at Borders & Barnes & Nobel to mention a few. It does a very
good job of documenting that which Oracle decided not to.
Dick Goulet
PS: There's a pocket reference too, mine is VERY beat up from use.
____________________Reply Separator____________________
Author: [EMAIL PROTECTED]
Date: 3/13/2001 1:15 AM
You can get this from source or install scripts.
Gints
procedure analyze_schema(schema varchar2, method varchar2,
estimate_rows number default null,
estimate_percent number default null, method_opt varchar2 default
null);
-- Analyze all the tables, clusters and indexes in a schema.
-- Input arguments:
-- schema
-- Name of the schema.
-- method, estimate_rows, estimate_percent, method_opt
-- See the descriptions above in sql_ddl.analyze.object.
-- Exceptions:
-- ORA-20000: Insufficient privileges for some object in this schema.
procedure analyze_part_object
(schema in varchar2 default null,
object_name in varchar2 default null,
object_type in char default 'T',
command_type in char default 'E',
command_opt in varchar2 default null,
sample_clause in varchar2 default 'sample 5 percent');
-- Equivalent to SQL "ANALYZE TABLE|INDEX [<schema>.]<object_name>
-- PARTITION <pname> [<command_type>] [<command_opt>]
[<sample_clause>]
-- for each partition of the object, run in parallel using job queues.
-- The package will submit a job for each partition
-- It is the users responsibilty to control the number of concurrent
-- jobs by setting the INIT parameter JOB_QUEUE_PROCESSES correctly
-- There is minimal error checking for correct syntax. Any error will
be
-- reported in SNP trace files.
-- Input arguments:
-- schema
-- schema of the object_name
-- object_name
-- name of object to be analyzed, must be partitioned
-- object_type
-- type of object, must be T(able) or I(ndex)
-- command_type
-- must be one of the following
-- - C(omput statistics)
-- - E(stimate statistics)
-- - D(elete statistics)
-- - V(alidate structure)
-- command_opt
-- Other options for the command type.
-- For C, E it can be FOR table, FOR all LOCAL indexes, FOR all
columns or
-- combination of some of the 'for' options of analyze statistics
(table)
-- For V, it can be 'CASCADE' when object_type is T
-- sample_clause
-- Specifies the sample clause to use when command_type is 'E'
"Bunyamin
K.Karadeniz" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<bunyamink@havels cc:
an.com.tr> Subject: DBMS_UTILITY ?
Sent by:
[EMAIL PROTECTED]
01.03.13 11:00
Please respond to
ORACLE-L
dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ) ;
1) wHAT DOES THAT PROCEDURE DO? I could not find it in the documentation.
Does it analyze all tables in a given user.?? I mean Does it do the below?
2) Then what is NULL and 5 is used for ?
Analyze table scott.xxx estimate statistics; // repeating for all tables of
user.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
