About configuring DevTest on an Oracle Database...

[soati01]

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

[Legacy User]

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