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]
