Re: SQL Tunning using Indexes

It's normal if we hints the SQL to use parallel table scan without any problem.

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:

: Don't forget that you also have to set
: parallel_max_servers, and parallel_min_percent.
: The commonest cause of
: 'max # of parallel processes'
: is then due to parallel servers not being
: released at the right time, so that even though
: processes, and parallel_max_processes seem
: to be big enough, Oracle still fails.

: --
: Jonathan Lewis
: Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
 

: Practical Oracle 8i: Building Efficient Databases
 

: Publishers: Addison-Wesley
: Book bound date: 8th Dec 2000
: See a first review at:
: http://www.ixora.com.au/resources/index.htm#practical_8i
: More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html

: Lynux wrote in message <8vp267$5au1_at_imsp212.netvigator.com>...

:>Nuno, we have already tested it after our previous post on a month before.
:>It works for 8.0.6 already after a parallel_index hints was added.
:>However, don't think it is perfect as sometimes I got an error of max # of
:>parallel processes attained when I set the degree as 5.  Funly that I can
:>saw that the number of concurrent processes was about 150 at that time.
:>A day after, we run the SQL again with the same degree and it run without
:>any error (concurrent processes is ~210).  And, we have set our # of
:>processes to be 400 in the init<SID>.ora
:>