Re: Parallel Query Option on 7.3.4

you can select * from sys.v$PQ_TQSTAT to monitor you parallel query execution.

Please make sure that you have correctly set the relevant Parallel query parameters in your init.ora
and that the system resources allow for the given values of "parallel_min_servers & parallel_max_servers& PARALLEL_MIN_PERCENTt"

Roman Gelfand wrote in message <71qf03$a93$1_at_news.monmouth.com>...
>select /*+ PARALLEL(TBL1, 5) */ fld1, fld2, fld3, fld4 from tbl1 order by
>fld5, fld6;
>
>The table tbl1 contains 5000 rows. Can anyone tell me why I am not seeing
>performance improvement using parallel query option.
>
>Thanks for your help
>
>

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1% M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE# M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I, M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM) M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ <.3DX,3$P-%0R,3$U,3E:#0I%3D0Z5D-!4D0-"@`` `
end Received on Wed Nov 04 1998 - 15:15:19 CST