Service Virtualization

Expand all | Collapse all

About configuring DevTest on an Oracle Database...

Jump to Best Answer
  • 1.  About configuring DevTest on an Oracle Database...

    Posted 05-23-2017 01:29 PM

    What are the good values for the config parameters to config DevTest to an Oracle Database?

    *.db_block_size=

    *.open_cursors=

    *.processes=

    *.memory_max_target=

    *.memory_target=

    *.pga_aggregate_target=

    *.sga_target=

    Tablespace size=

    Index size=

     

    We have been asked about it from a Client.

     

    #oracle_db #portalconfiguration



  • 2.  Re: About configuring DevTest on an Oracle Database...
    Best Answer

    Posted 05-23-2017 02:30 PM

    I have not seen any published DevTest recommendations other than the DBMS default for most of the options above.  For example, db_block_size=8192, open_cursors=50 and so on.

     

    Perhaps, others have additional information on these settings.

     

    Depending on VSE usage (functional vs performance) and the # of days your DB cleaners are set to run, the recommendations are:

     

    Registry tablespace = 500GB

    Enterprise Dashboard tablespace = 50GB

    I found the above references here: System Requirements - DevTest Solutions - 10.0 - CA Technologies Documentation