On 10/20/09 10:49, Matt V. wrote:
I've tried your script lockutil and now the output: lockutil -n 44 lockstat_kWP.out CPU-util Lock Caller 0.191 kstat_chain_lock kstat_hold 0.036 kstat_chain_lock kstat_rele 0.014 mod_lock mod_hold_stub 0.006 kpr_mutex hat_page_relocate 0.002 0x1992fb0 page_get_mnode_freelist 0.002 anonhash_lock+0x118 anon_decref_pages 0.001 dtrace_lock dtrace_ioctl 0.001 0x3000cacb780 lwp_unpark 0.001 anonpages_hash_lock+0x80 anon_map_privatepages 0.001 pse_mutex+0x600 page_trylock 0.001 pidlock pr_lookup_procdir 0.000 vx_worklist_lk vx_worklist_process 0.000 0x3000cacb780 post_syscall 0.000 0x3000cacb780 stop 0.000 0x19930d8 page_list_add 0.000 pidlock waitid 0.000 dtrace_lock dtrace_ioctl_helper 0.000 dtrace_lock dtrace_helpers_duplicate 0.000 cpu_lock system_misc_kstat_update 0.000 dtrace_lock dtrace_helpers_destroy 0.000 vx_sched_lk vx_worklist_thread 0.000 kstat_chain_lock kstat_create_zone 0.000 anonhash_lock+0x118 anon_dup_fill_holes 0.000 pse_mutex+0x6c0 page_unlock 0.000 pidlock freectty_lock 0.000 anon_array_lock+0x1800 anon_array_enter 0.000 0x1992988 page_list_sub 0.000 pidlock thread_exit 0.000 0x3000cacb780 clock_tick_process 0.000 0x3000cacb780 trap_cleanup 0.000 pidlock proc_exit 0.000 pidlock cv_wait_sig_swap_core 0.000 cpu_lock pset_getloadavg [...]Is the problem corrected with oracle 10.2.0.4.0. 11g please ? Thanks Matt
Fixed in both, according to Andy Harrison. From his blog: http://blogs.sun.com/hippy/entry/multiple_oracle_instances_performance_issue "...which then resulted in Oracle bug and Patch 8531434 - "KSTAT CALLS BY MMNL/CJQ0 INCUR HIGH SYSTEM CPU WHEN RUNNING NUMEROUS INSTANCES" being logged and fixed for 10.2.0.4.0. 11g doesn't appear effected by this issue." - Steve _______________________________________________ perf-discuss mailing list perf-discuss@opensolaris.org
