Re: Ho to do it in PARALELL (multiple ANALYZE TABLE at the same time)

Andreas Wizemann wrote:
>
> 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 ?
>
> Regards
> Andreas
> Andreas Wizemann

Script 1:
select 'analyze ... etc'
from user_objects
where object_type = 'TABLE'
and mod(object_id,2) = 0

Script 2:
select 'analyze ... etc'
from user_objects
where object_type = 'TABLE'
and mod(object_id,2) = 1

That lets you parallelize them ... Alternatively, I've got a similar pl/sql routine on my site (see sig)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."