Pastikan nilai parameter parallel_max_servers nya lebih dari 0.
Contoh:
SQL> conn / as sysdba
SQL> alter system set parallel_max_servers=4;
SQL> show parameter parallel
NAME TYPE VALUE
------------------------------------ ----------- ------
parallel_max_servers integer 4
SQL> conn scott/tiger
SQL> set autotrace traceonly explain
SQL> select /*+ PARALLEL(emp,4) */ * from emp;
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=1 Card=16 Bytes=13
92)
1 0 PX COORDINATOR
2 1 PX SEND* (QC (RANDOM)) OF ':TQ10000' (Cost=1 Card=16
Byt :Q1000
es=1392)
3 2 PX BLOCK* (ITERATOR) (Cost=1 Card=16
Bytes=1392) :Q1000
4 3 TABLE ACCESS* (FULL) OF 'EMP' (TABLE) (Cost=1
Card=1 :Q1000
6 Bytes=1392)
2 PARALLEL_TO_SERIAL
3 PARALLEL_COMBINED_WITH_CHILD
4 PARALLEL_COMBINED_WITH_PARENT
Bowo
--- In [email protected], "cyuniart" <[EMAIL PROTECTED]> wrote:
> Selamat malam,
> Agar query bisa dijalankan secara parallel apa saja ya yang harus di
> setting, saya coba jalankan skrip
>
> select /*+ parallel(t,2) */ * from t;
>
> tapi dilihat dari explain plan kq sepertinya tidak dijalankan secara
> parallel. Apakah parameter parallel_automatic_tuning mempengaruhinya .
> .(saya set true)..
>
> thx,
> Condro
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
