This content has been marked as final. Show 3 replies
Is there any ESRI Professional to answer ?
1.1 > when we create another user who will own the other schema, we need a default Tablespace for that user, do we need a separate Tablespace of we can use the sde tablespace? what is the best practice.?
You don't need a separate tablespace, but it would be the best practice.
1.2 > the guide Guid reads that we need to modify "Data_Dictionary" parameters, whereaswe have already tuned the parameters for SDE user, now how can we modify the same parameters for the other user ? do we need to add these parameter twice, if so is there any example ?
1.3> the dbtune file that has been modified for vector and raster storage, now when we load data to the other schema, will the ArcSDE follow the same dbtune file ?
Each schema geodatabase has its own dbtune table. If you connect to the master (SDE) schema, ArcSDE will read the SDE.DBTune table. If you connect to the Scott schema, ArcSDE will read the Scott.DBTune table. You can copy and modify the dbtune file you used for the master schema, to support workflows you plan on using with the schema geodatabase (Scott). You would them either save that file to SDEHome\etc\sdedbtune.sde (don't forget to same the current one to something else) and create the schema geodatabase, or load the new dbtune file to the schema geodatabase after it is created (using the SDEDBTune command).
2.1 > as ESRI has some recomendation for memory allocation to Oracle SGA and PGA, as when we create an Oracle database it also asks for memory allocation, in this case how can we allocate enough memory to each database, if we create let say three databases? there is no detail available in any document.
If you create multiple database, then you will have to allocate resources for each of them. These are independent, so if you would like to follow the recommendations, you will have to allocate the recommended amount of memory and disk for each database.
Its great help