Select to view content in your preferred language

Best practices for DBTUNE in Oracle 11R2

1690
0
03-25-2013 12:43 PM
Ulises
by
Frequent Contributor
Are there any best practices or suggestions for dbtune parameters for ArcGIS 10.1 in Oracle 11gR2 using ASM???  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?  Our geodatabase stores a few big rasters (read only) and a huge versioned polygon feature class among other read only features.  We also use JTX (WMX in 10).  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.  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).

Any suggestions are welcome...

thanks.
Ulises Feliciano Troche
0 Kudos
0 Replies