Re: Procedure Storage/Analyze Question

On 12 Sep 1996 21:17:11 GMT, Wayne Linton <Linton_Wayne/SCAN6_at_shell.ca> wrote:

>Barbara Hiles wrote:
>>
>> Where do these get stored? Is there a table I can list to see what is out
>> there?

Statistics are stored in the SYSTEM tablespace in the tables underlying DBA_TABLES, DBA_INDEXES, etc.

>> Specifically, I am trying to execute dbms_utility.analyze_schema. I get
>> unable to open file.
>> Does this mean it's not loaded? Or does it mean something else?
>> I'm in sqlplus trying to do a start on this - is that right?
>> Do I sound confused? (I am)
>
>If you are doing this sor of thing for the first time, use the SQL*Plus
>command directly - ANALYZE. The dbms_* procuedures work within a PL/SQL
>block and permit you to 'program' further things into your work.
>
>Use the ANALYZE command, get to know how it works and what it does for
>you and where it puts what information. Then you can move on to pl/sql
>programs if you *need* to.
>
>
>--
>R. Wayne Linton, I.S.P.
>Database & Systems Management
>Shell Canada Ltd.

You can run analyze_schema from SQL*Plus as follows:

  execute dbms_utility.analyze_schema('schema_name','action');

This creates an anonymous PL/SQL block to run the command.

Jim Joslin Received on Fri Sep 13 1996 - 00:00:00 CEST