Re: Analyze
From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 1998/10/08
Message-ID: <6vkn88$9us$2_at_news.seed.net.tw>#1/1
Date: 1998/10/08
Message-ID: <6vkn88$9us$2_at_news.seed.net.tw>#1/1
>Josef Huber wrote:
> Hello,
>
> Is there a command with that i can analyze a entire schema ?
You can use DBMS_UTILITY.ANALYZE_SCHEMA(schema, method, ....),
Ex:
EXEC DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE'); Received on Thu Oct 08 1998 - 00:00:00 CEST