Mantab nih Kang Ujang, sudah langsung bisa menerka OS-nya apa. :) OS yang saya pake HP-UX 11.23.
Berikut saya lampirkan kernel dari system yang saya pegang (kebeneran saya baru pegang, yang konfigur system ini sudah resign). Terima kasih dan salam, Indra Cahaya On Wed, Jan 6, 2010 at 8:43 AM, Ujang Jaenudin <[email protected]>wrote: > > > keliatannya hp-ux.... versi berapa ya? > kernel setting untuk alokasi memory mesti dibenahi...sptinya > > > On Wed, Jan 6, 2010 at 8:13 AM, Faiz Yahya > <[email protected]<faiz.jahja%40gmail.com>> > wrote: > > > Dear all, > > > > Saya menemukan keanehan dalam system yang saya maintain, yaitu jika > dilihat > > di OEM terdapat peringatan bahwa Memory Utilization mencapai di atas 95% > > bahkan bisa 99.49%. Di sisi lain ketika saya memeriksa Buffer Cache Ratio > > bisa mencapai 97% - 99.49%. > > > > Adakah hubungan di antara 2 nilai di atas? Dan apakah database tersebut > > dalam keadaan sehat? > > > > Data server saya adalah: > > * RAM 4G > > * Swap 8G > > * SGA 2G > > > > Parameter Oracle adalah: > > *.db_block_size=8192 > > *.db_file_multiblock_read_ > > count=32 > > *.db_files=200 > > *.db_name='test' > > *.db_writer_processes=2 > > *.dbwr_io_slaves=4 > > *.disk_asynch_io=TRUE > > *.dml_locks=2500 > > *.instance_name='test' > > *.job_queue_processes=20 > > *.local_listener='LISTENER' > > *.log_archive_dest_1='LOCATION=/arch001/test MANDATORY' > > *.log_buffer=3549696 > > *.log_buffer=28397568 > > *.log_checkpoint_interval=10000 > > *.log_checkpoints_to_alert=true > > *.max_dump_file_size='10240' > > *.nls_comp='binary' > > *.nls_language='AMERICAN' > > *.nls_sort='binary' > > *.nls_territory='AMERICA' > > *.open_cursors=800 > > *.os_authent_prefix='OPS$' > > *.processes=800 > > *.remote_login_passwordfile='exclusive' > > *.remote_os_authent=true > > *.session_cached_cursors=100 > > *.sessions=800 > > *.sga_max_size=2048M > > *.sga_target=2048M > > *.timed_statistics=false > > *.undo_management='auto' > > *.undo_retention=900 > > *.user_dump_dest='/var/opt/oracle/test/udump' > > > > # swapinfo -tam > > Mb Mb Mb PCT START/ Mb > > TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME > > dev 8192 67 8125 1% 0 - 1 /dev/vg00/lvol2 > > reserve - 3775 -3775 > > memory 4065 1430 2635 35% > > total 12257 5272 6985 43% - 0 - > > > > # ipcs -mob > > IPC status from /dev/kmem as of Wed Jan 6 08:09:41 2010 > > T ID KEY MODE OWNER GROUP NATTCH SEGSZ > > Shared Memory: > > m 0 0x411811f3 --rw-rw-rw- root root 0 348 > > m 1 0x4e0c0002 --rw-rw-rw- root root 3 61760 > > m 2 0x41201c66 --rw-rw-rw- root root 2 8192 > > m 3 0x00a5c581 --rw------- sfmdb users 7 10469376 > > m 2195460 0x320a1bc0 --rw------- oracle oinstall 52 2164269056 > > > > # vmstat 1 300 > > procs memory > > page faults cpu > > r b w avm free re at pi po fr de sr > > in sy cs us sy id > > 1 0 0 746135 12314 37 13 0 0 0 0 0 > > 1193 3452 150 0 1 99 > > 1 0 0 746135 12235 7 0 2 0 0 0 0 > > 1042 2638 135 0 0 100 > > 1 0 0 746135 12235 5 0 1 0 0 0 0 > > 1036 2192 127 0 0 100 > > 1 0 0 746135 12235 4 0 0 0 0 0 0 > > 1049 4039 179 2 0 98 > > 1 0 0 746135 12235 3 0 0 0 0 0 0 > > 1048 3520 174 0 0 100 > > 1 0 0 746135 12235 2 0 0 0 0 0 0 > > 1047 2967 165 0 0 100 > > 1 0 0 746135 11855 50 12 0 0 0 0 0 > > 1047 9833 165 2 1 97 > > > > > > Terima kasih dan salam, > > Faiz > > > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: > > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > > Website: http://indooracle.wordpress.com > > http://www.facebook.com/group.php?gid=51973053515 > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > -- > thanks and regards > ujang | oracle dba | mysql dba > jakarta - indonesia > > [Non-text portions of this message have been removed] > > > ---------- Tunable Value Expression Changes NSTREVENT 50 Default NSTRPUSH 16 Default NSTRSCHED 0 Default STRCTLSZ 1024 Default STRMSGSZ 0 Default acctresume 4 Default acctsuspend 2 Default aio_listio_max 256 Default Immed aio_max_ops 2048 Default Immed aio_monitor_run_sec 30 Default Immed aio_physmem_pct 10 Default aio_prio_delta_max 20 Default Immed aio_proc_thread_pct 70 Default Immed aio_proc_threads 1024 Default Immed aio_req_per_thread 1 Default Immed allocate_fs_swapmap 0 Default alwaysdump 0 Default Immed chanq_hash_locks 256 Default core_addshmem_read 0 Default Immed core_addshmem_write 0 Default Immed create_fastlinks 0 Default dbc_max_pct 50 Default Immed dbc_min_pct 5 Default Immed default_disk_ir 0 Default desfree_pct 0 Default Auto disksort_seconds 0 Default dma32_pool_size 268435456 Default dmp_pathswitch_blks_shift 10 Default dmp_rootdev_is_vol 0 Default dmp_swapdev_is_vol 0 Default dnlc_hash_locks 512 Default dontdump 0 Default Immed dst 1 Default dump_compress_on 1 Default Immed enable_idds 0 Default Immed eqmemsize 15 Default executable_stack 0 0 Immed fr_statemax 800000 Default Immed fr_tcpidletimeout 86400 Default Immed fs_async 0 Default fs_symlinks 20 Default Immed ftable_hash_locks 64 Default gvid_no_claim_dev 0 Default hp_hfs_mtra_enabled 1 Default intr_strobe_ics_pct 100 Default Auto io_ports_hash_locks 64 Default ioforw_timeout 0 Default Auto ipf_icmp6_passthru 0 Default Immed is_vxtrace_enabled 1 Default ksi_alloc_max 240000 nproc*8 Immed ksi_send_max 32 Default lotsfree_pct 0 Default Auto max_acct_file_size 2560000 Default Immed max_async_ports 50 Default max_mem_window 0 Default max_thread_proc 4096 4096 Immed maxdsiz 4294963200 4294963200 Immed maxdsiz_64bit 8589934592 8589934592 Immed maxfiles 2048 Default maxfiles_lim 4096 Default Immed maxrsessiz 8388608 Default maxrsessiz_64bit 8388608 Default maxssiz 401604608 401604608 Immed maxssiz_64bit 1073741824 1073741824 Immed maxtsiz 100663296 Default Immed maxtsiz_64bit 1073741824 Default Immed maxuprc 27001 nproc*9/10+1 Immed maxvgs 10 Default msgmap 1026 Default msgmax 8192 Default Immed msgmnb 16384 Default Immed msgmni 30000 nproc msgseg 32767 32767 msgssz 96 Default msgtql 30000 nproc ncdnode 150 Default Immed nclist 8292 Default ncsize 243072 ninode+1024 nfile 452048 15*nproc+2048 Imm (auto disabled) nflocks 30000 nproc Imm (auto disabled) ninode 242048 8*nproc+2048 nkthread 52516 nproc*7/4+16 Immed nproc 30000 30000 Immed npty 60 Default nstrpty 60 60 nstrtel 60 Default nswapdev 10 Default nswapfs 10 Default nsysmap 8400 Default nsysmap64 8400 Default o_sync_is_o_dsync 0 Default pa_maxssiz_32bit 83648512 Default pa_maxssiz_64bit 536870912 Default pagezero_daemon_enabled 1 Default Immed pfdat_hash_locks 128 Default physical_io_buffers 768 Default Auto pthread_condvar_prio_boost 0 Default Immed region_hash_locks 128 Default remote_nfs_swap 0 Default rng_bitvals 9876543210 Default rng_sleeptime 2 Default rtsched_numpri 32 Default scroll_lines 100 Default scsi_max_qdepth 8 Default Immed scsi_maxphys 1048576 Default secure_sid_scripts 0 0 Immed semaem 16384 Default semmni 30000 nproc semmns 60000 semmni*2 semmnu 29996 nproc-4 semmsl 2048 Default Immed semume 100 Default semvmx 32767 32767 sendfile_max 0 Default shmmax 3865470566 3865470566 Immed shmmni 512 512 Immed shmseg 120 120 Immed st_ats_enabled 0 Default st_fail_overruns 0 Default st_large_recs 0 Default st_san_safe 0 Default Immed streampipes 0 Default swapmem_on 1 Default swchunk 2048 Default sysv_hash_locks 128 Default tcphashsz 2048 Default timeslice 10 Default timezone 420 Default unlockable_mem 0 Default vnode_cd_hash_locks 128 Default vnode_hash_locks 128 Default vol_checkpt_default 10240 Default vol_dcm_replay_size 262144 Default vol_default_iodelay 50 Default vol_fmr_logsz 4 Default vol_max_bchain 32 Default vol_max_nconfigs 20 Default vol_max_nlogs 20 Default vol_max_nmpool_sz 4194304 Default Immed vol_max_prm_dgs 1024 Default vol_max_rdback_sz 4194304 Default Immed vol_max_vol 8388608 Default vol_max_wrspool_sz 4194304 Default Immed vol_maxio 1024 Default vol_maxioctl 32768 Default vol_maxkiocount 2048 Default vol_maxparallelio 256 Default vol_maxspecialio 1024 Default vol_maxstablebufsize 256 Default vol_min_lowmem_sz 532480 Default Immed vol_mvr_maxround 256 Default vol_nm_hb_timeout 10 Default vol_rootdev_is_vol 0 Default vol_rvio_maxpool_sz 4194304 Default Immed vol_subdisk_num 4096 Default vol_swapdev_is_vol 0 Default vol_vvr_transport 1 Default vol_vvr_use_nat 0 Default volcvm_cluster_size 16 Default volcvm_smartsync 1 Default voldrl_max_drtregs 2048 Default voldrl_min_regionsz 512 Default voldrl_volumemax_drtregs 256 Default voliomem_chunk_size 65536 Default voliomem_maxpool_sz 4194304 Default voliot_errbuf_dflt 16384 Default voliot_iobuf_default 8192 Default voliot_iobuf_limit 131072 Default voliot_iobuf_max 65536 Default voliot_max_open 32 Default volpagemod_max_memsz 6144 Default Immed volraid_rsrtransmax 1 Default vps_ceiling 64 64 vps_chatr_ceiling 1048576 Default vps_pagesize 4 Default vx_maxlink 32767 Default vx_ninode 0 Default vxfs_bc_bufhwm 0 Default vxfs_ifree_timelag 0 Default Immed vxtask_max_monitors 32 Default [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
