Log File Pool Mode in Oracle

02-07-2022 03:24 AM
Occasional Contributor II


I am confused about the use of Log File Pool. I have read : https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/logfiles-oracle.htm. It seems that the environment I am working now is a mix of Shared and Session-based log. I said its a mix because the geodatabase is edited via desktop client and due to lack of adequate licenses,  some edits are going through FS accessed by ArcGIS Pro and web apps.

0. How to see the current pool mode ?

1. Which Log File Pool is the best option ?

2. How do you determined that such mode is the best ? is there any metrics / variables to be checked to determine whether the chosen mode is the best option ?



0 Kudos
1 Reply
Esri Contributor

You can find out your Geodatabase's mode from the SDE.SERVER_CONFIG table. Between Shared and Session based, the difference is the ALLOWSESSIONLOGFILE parameter. For Shared it is FALSE and for Session it is TRUE. For Oracle you should be using Shared mode. This will be the mode for your whole Geodatabase, regardless of the Client you use for your editing.

0 Kudos