Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Analyzing all tables ?
Marco,
If you have a list of tables, you would need to analyze each object
individually. Analyzing the table will analyze the indexes also.
The easier way is to analyze the entire schema using
DBMS_UTILITY.ANALYZE_SCHEMA(schema_name, compute or estimate) procedure.
Remember, the 'analyze' will lock the tables temporarily.
If this causes problems to other users, run analyze at night or just
'estimate' statistics.
Hope this helps.
Raj
In article <6fgd3h$32a$1_at_news.NL.net>,
"Marco Nedermeijer" <m.n.nedermeijer_at_rtd.nl> wrote:
>
> Is it possible to analyze all tables, indexes and clusters (in one step) ?
> Or must i write a script where all tables seperately are analyzed ?
>
> Thanks,
>
> Marco Nedermeijer
> m.n.nedermeijer_at_rtd.nl
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Mar 27 1998 - 00:00:00 CST