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]> 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] > 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]
