Database freezes/Hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Database freezes/Hangs

  1. #1
    Join Date
    Nov 1999
    Posts
    226

    Angry

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width