Re: SQL Tunning using Indexes

From: Lynux <lynux_at_netvigator.com>
Date: 25 Nov 2000 18:59:19 GMT
Message-ID: <8vp267$5au1@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

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

: I think I used it in 8.0.3 first, but haven't : checked all the intermediate versions.  

: --
: 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



: Nuno Souto wrote in message <3a1fa576.887248_at_news-server>...

:>On Fri, 24 Nov 2000 20:57:21 -0000, "Jonathan Lewis"
:><jonathan_at_jlcomp.demon.co.uk> wrote:
:>
:>>
:>>It's certainly an option to consider.
:>>In fact it's always worth considering having
:>>different degrees of parallelism on the index
:>>and the table when using partitioned tables.
:>>There may be cases where (for example)
:>>a parallel degree 10 scan of a table and a
:>>parallel degree 5 index range scan perform
:>>at about the same speed, but one is more
:>>desirable than the other for some application
:>>dependent reason.
:>>
:>
:>Jonathan,
:>
:>Parallel index range scan is only available in 8i, isn't it? I don't
:>think it can be done by hint on 8.0.
:>Please correct me if I'm wrong.
:>I've got a partitioned table and local index that could benefit from
:>parallel index range scan, but I'm stuck on 8.0... (third party s/w!)
:>
:>TIA
:>
:>Cheers
:>Nuno Souto
:>nsouto_at_bigpond.net.au.nospam
:>http://www.users.bigpond.net.au/the_Den/index.html
Received on Sat Nov 25 2000 - 12:59:19 CST