DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Nov 1999



    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


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.