-
HI
I work on an 815 DB and we have a web site runnning . My DB is good at normal days but sometimes when we have a high hit rate on the web site , The DB hangs for that time (slows to such an extent that the sqlplus login on command level also takes 1 minute) . Please help me and let me know if anybody has faced such a situation and what can i do to prevent it .
I am putting my /etc/system file for refelrence . Please let me know if there is anything wrong or incorrect in this
set shmsys:shminfo_shmmax=1073741824
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni = 100
set shmsys:shminfo_shmseg = 10
set semsys:seminfo_semmni = 100
set semsys:seminfo_semmsl = 1600
set semsys:seminfo_semmns = 5000
set semsys:seminfo_semopm = 100
set semsys:seminfo_semvmx = 32767
Regards
-
Have to considered using os performance monitoring tools when u face this problem? This should help u to assess the performance of u'r database & also if u are running short of system resources.
Tools such as
sar -u 5 5 (reports CPU utilization)
sar -r 5 5 (reports memory utilization)
sar -w 5 5 (to check for swapping)
swap -l (swap space usage)
mpstat (statistics per processor)
iostat 5 5(disk activity)
sar -p 10 10(paging activity)
With regards.
