Re: Analyze tables+ind
From: timo <timo.talja_at_luukku.com>
Date: Wed, 19 Nov 2008 08:49:07 GMT
Message-ID: <7qQUk.63$5q2.15@read4.inet.fi>
Date: Wed, 19 Nov 2008 08:49:07 GMT
Message-ID: <7qQUk.63$5q2.15@read4.inet.fi>
Hi,
DB is 10.2 running on linux.
BR,
Timo
"timo" <timo.talja_at_luukku.com> wrote in message
news:XfQUk.60$5q2.44_at_read4.inet.fi...
> Hi,
> I'd like to analyze one schema's all tables and indexes every night -
> should I implement a PL/SQL-procedure for this and add it to Database
> Control/Scheduler Jobs ? - there seems to some "gather stats"-jobs already
> but those are "smart-ones" and this one schema is vital an stats must in
> up-to-date.
>
> BR,
> Timo
>
Received on Wed Nov 19 2008 - 02:49:07 CST