Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ho to do it in PARALELL (multiple ANALYZE TABLE at the same time)
Andreas Wizemann <AWizemann_at_fvvag.de> wrote in message news:<cv35vts17an941spmos0je0npb80noabbo_at_4ax.com>...
> Hi,
> i need to run ANALYZE TABLE on lots of tables.
> So i wrote a script to do it. But it only does one command at a time.
> Is there a way to do this statement in "background" as i can do in
> unix with adding an & (Ampersand) at the end of the line ?
Sure, implement it as a stored procedure and schedule it using dbms_job. Make sure you divide the tables among the sessions - like Connor stated. Use the monitoring option to keep track of changes in the table and to enable you to decide which tables need to be analyzed. This can save a lot of time.
Ronald.