topic Best practices for DBTUNE in Oracle 11R2 in Data Management Questions https://community.esri.com/t5/data-management-questions/best-practices-for-dbtune-in-oracle-11r2/m-p/231257#M13112 <HTML><HEAD></HEAD><BODY><SPAN>Are there any best practices or suggestions for dbtune parameters for ArcGIS 10.1 in Oracle 11gR2 using ASM???&nbsp; We are going to move our existing production environment from Oracle 9i using file system storage to ASM in Oracle 11R2 and wonder if there is any documented recommendations regarding this?&nbsp; Our geodatabase stores a few big rasters (read only) and a huge versioned polygon feature class among other read only features.&nbsp; We also use JTX (WMX in 10).&nbsp; Already check the whitepaper "Best practices for storing the ArcGIS Workflow Manager Workspace in an Enterprise Geodatabase for Oracle" and give me a some ideas for the WMX repository, but want to know if there is anything else around.&nbsp; Since we are going to use Oracle ASM, it looks like there is no need to create a lot of tablespaces besides organization of my different types of layers (raster, vector_ro, vector_rw, sde, and wmx).</SPAN><BR /><BR /><SPAN>Any suggestions are welcome...</SPAN><BR /><BR /><SPAN>thanks.</SPAN></BODY></HTML> Mon, 25 Mar 2013 19:43:56 GMT Ulises 2013-03-25T19:43:56Z Best practices for DBTUNE in Oracle 11R2 https://community.esri.com/t5/data-management-questions/best-practices-for-dbtune-in-oracle-11r2/m-p/231257#M13112 <HTML><HEAD></HEAD><BODY><SPAN>Are there any best practices or suggestions for dbtune parameters for ArcGIS 10.1 in Oracle 11gR2 using ASM???&nbsp; We are going to move our existing production environment from Oracle 9i using file system storage to ASM in Oracle 11R2 and wonder if there is any documented recommendations regarding this?&nbsp; Our geodatabase stores a few big rasters (read only) and a huge versioned polygon feature class among other read only features.&nbsp; We also use JTX (WMX in 10).&nbsp; Already check the whitepaper "Best practices for storing the ArcGIS Workflow Manager Workspace in an Enterprise Geodatabase for Oracle" and give me a some ideas for the WMX repository, but want to know if there is anything else around.&nbsp; Since we are going to use Oracle ASM, it looks like there is no need to create a lot of tablespaces besides organization of my different types of layers (raster, vector_ro, vector_rw, sde, and wmx).</SPAN><BR /><BR /><SPAN>Any suggestions are welcome...</SPAN><BR /><BR /><SPAN>thanks.</SPAN></BODY></HTML> Mon, 25 Mar 2013 19:43:56 GMT https://community.esri.com/t5/data-management-questions/best-practices-for-dbtune-in-oracle-11r2/m-p/231257#M13112 Ulises 2013-03-25T19:43:56Z