Re: Monitoring parallelism

afilonov_at_yahoo.com (Alex Filonov) wrote:

>If you are using 8i, you also need to set
>optimizer_percent_parallel to something greater than 0. You can do it in init.ora
>or at a session level. It's also a good idea to increase hash_area_size to 8M at
>least (Oracle recommended value).

OK, I will try that. Does this parameter have an influence on Oracle's tendence to do full table scans? It seems that when parallelizing things, Oracle will more likely do full table scans - bad.

>Table should be created or altered to use parallel query. Or you can hint your
>query to use parallel query. Hints work on base tables only, they don't work on
>views (at least with 7.3.3, 8.0, 8.1, don't know about 9 yet).

As I wrote in other parts of this thread, I found out that it is enough to parallelize tables to get things done in parallel, without changing any init.ora parameter.

If I use PARALLEL_AUTOMATIC_TUNING, should then the degree of parallelism for the particular table be set to default? (Since it should work *automatically*). I could not really understand the meaning of the default degree of parallelism for a table. Received on Mon Aug 19 2002 - 18:21:18 CDT