Re: dbms_stats

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 29 Dec 2004 22:41:33 -0800
Message-ID: <41d3a210$1_2@127.0.0.1>

Oradba Linux wrote:

> Is gather_index_stats parallelized? In one of the white papers downloaded
> from centrex consulting the author says gathering index
> stats is not parallelized? Is he wrong?
> I did a tkprof and i saw that the SQL executes with parallel(2) hint.

you can also use DBMS_STATS to gather statistics in parallel

Source:
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_stats.htm#ARPLS059

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Dec 30 2004 - 00:41:33 CST