When setting up the Reviewer workspace in an enterprise geodatabase, is it absolutely necessary to configure cache tables for users?

[JenniferMoczygemba]

When setting up the Reviewer workspace in an enterprise geodatabase, is it absolutely necessary to configure cache tables for users? This is Step 5 of the Storing the Reviewer workspace in an enterprise geodatabase article found on the ArcGIS Resources page.

We have an Oracle geodatabase, and I'm just wondering if we skipped this step, will performance be significantly impacted? It can be tough to coordinate with our DBA, so thought I'd throw this out there to see if anyone else had moved on without performing this step.

Thanks in advance for any advice and comments.

Jennifer

[MarceloMarques · Accepted solution]

Hello Jennifer,

My name is Marcelo.

I am the author of the ArcGIS Help topic about database best practices for the Reviewer workspace.

Introduction to storing the Reviewer workspace in a geodatabase in Oracle

Yes, it is absolutely necessary and important to configure the Oracle Enterprise Geodatabase Log File tables or you might encounter performance issues.

Log file tables configuration for the Reviewer workspace in Oracle

Thanks,

Marcelo Marques

GIS Technical Manager, Oracle OCP

Esri Production Mapping Team

Esri Enteprise Mapping and Charting Databases
Best Practices

[JenniferMoczygemba]

Okay, thank you for your help, Marcelo!

Jennifer