Untuk mengetahui apakah kedua prosesor BENAR2 dipakai, seharusnya dimonitor dari sisi OS. Kalau windows bisa pake Task Manager???, kalau unix bisa pake top atau command2 spesifik os lain.
Saya tidak merekomendasikan Anda mengaktifkan parallel proses karena cpu cuma 2 (check parameter yg berhub dengan proses parallel di SQL: parallel_automatic_tuning, parallel_adaptive_multi_user, parallel_max_servers,parallel_min_servers). KECUALI Anda yakin bahwa SQL yg ingin dijalankan secara parallel dilakukan pada waktu tidak ada user lain lagi yg mengakses database. regards, tomi --- Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > pak tomi, > > [EMAIL PROTECTED] oracle]$ uname -r > 2.4.2-2smp > > SQL> show parameter cpu; > NAME TYPE > VALUE > ------------------------------------ ----------- > ------------------------------ > cpu_count integer 2 > parallel_threads_per_cpu integer 2 > > > SQL> show parameter parall; > NAME TYPE > VALUE > ------------------------------------ ----------- > ------------------------------ > fast_start_parallel_rollback string LOW > log_parallelism integer 1 > parallel_adaptive_multi_user boolean > FALSE > parallel_automatic_tuning boolean > FALSE > parallel_execution_message_size integer > 2148 > parallel_instance_group string > parallel_max_servers integer 0 > parallel_min_percent integer 0 > parallel_min_servers integer 0 > parallel_server boolean > FALSE > parallel_server_instances integer 1 > parallel_threads_per_cpu integer 2 > recovery_parallelism integer 0 > > dari parameter2 di atas, untuk memonitoring bahwa > kedua procs tsb dipakai, > darimana ya? > > > regards > > --ujang __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
