Re[2]: DBMS_UTILITY ?

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: G.Plivna_at_itsystems.lv
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 <ORACLE-L_at_fatcity.com>       
                    <bunyamink_at_havels        cc:                                
                                      
                    an.com.tr>               Subject:     DBMS_UTILITY ?        
                                      
                    Sent by:                                                    
                                      
                    root_at_fatcity.com                                            
                                      
                                                                                
                                       
                                                                                
                                       
                    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: G.Plivna_at_itsystems.lv

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

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: 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).