Topic
  • 1 reply
  • Latest Post - ‏2012-05-23T22:09:41Z by RuthHildebrand-Lund
SystemAdmin
SystemAdmin
693 Posts

Pinned topic Oracle DB parameters

‏2012-05-23T08:23:53Z |
Hello,

Is there any suggestion on the DB tuning or parameter setting?

These are the principal parameter that I need to know:

db_block_size
processes
open_cursors

My test environment:
Windows Server 2008 R2 Std 2GHz CPU, 2Gb RAM
Oracle 11g R2 DB Server
Updated on 2012-05-23T22:09:41Z at 2012-05-23T22:09:41Z by RuthHildebrand-Lund
  • RuthHildebrand-Lund
    RuthHildebrand-Lund
    19 Posts

    Re: Oracle DB parameters

    ‏2012-05-23T22:09:41Z  
    Not sure which version of software you are using, but take a look at the following for our performance recommendations in general, and for specific items that relate to Oracle:

    P8 4.5 Performance Tuning Guide

    http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC=SRX&PBL=GC31-5483-09

    Performance Tuning information in the P8 5.1 InfoCenter

    http://publib.boulder.ibm.com/infocenter/p8docs/v5r1m0/index.jsp?topic=%2Fcom.ibm.p8.performance.doc%2Fp8ppt000.htm