ArcMap

Log file tables configuration for the NIS workspace in Oracle

ArcMap 10.8
|
帮助归档
ArcGIS Desktop 处于成熟支持阶段，将于 2026 年 3 月 1 日停用。 当前没有发布 ArcGIS Desktop 未来版本的计划，建议您迁移到 ArcGIS Pro。 有关详细信息，请参阅从 ArcMap 迁移至 ArcGIS Pro。

企业级地理数据库使用日志文件表来维护所选记录的列表。每次选择指定大小的内容时会将记录写入日志文件表以供应用程序之后使用，对版本化数据库执行协调或提交，或者在客户端应用程序中完成离线编辑检出。日志文件表中存储了所选要素的 ObjectID，这样便可重新显示这些要素。支持信息的更快速分析和处理。

在 ArcGIS 中，默认情况下，如果选择集包含 100 或 100 条以上记录，则会使用日志文件表。100 个要素这个阈值可在注册表中设置。可对此阈值进行更改；但 Esri 不建议进行此操作。没有任何证据表明更改此阈值可改善性能，对其进行更改可能造成性能问题。

日志文件表在 ArcMap 中为每个已连接的地理数据库编辑者/查看者用户存储 100 个以上的要素选择。建议将日志文件表存储在单独的表空间中；这可以通过 DBTUNE 表实现。

When working with results in the NIS workspace, it is best to understand the log file table configuration options so you can choose the right option for your database needs. There are four different log file options: shared, session-based, stand-alone, and pools of session-based or stand-alone log files.

Oracle 中的地理数据库使用作为日志文件表创建诱因的用户所拥有的全局临时表。 无创建表所需数据库权限的用户将使用 sde 用户所拥有的全局临时日志文件表。

Creating log file tablespaces

Use the following statement to create log file tablespaces in Oracle.

CREATE SMALLFILE TABLESPACE gdblogfile
DATAFILE 'D:\ORACLE\ORADATA\NISDB\GDB\gdblogfile01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 100M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE gdblogfileidx
DATAFILE 'D:\ORACLE\ORADATA\NISDB\GDB\gdblogfileidx01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 100M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

Changing DBTUNE log file parameters

在创建数据文件之后，修改 DBTUNE 表以加入新的配置关键字。根据此新关键字，数据和数据库对象将存储在之前定义的表空间位置中。DBTUNE 表存储在 Oracle 中的地理数据库中。要修改 DBTUNE 表，有必要将 DBTUNE 表导出至文本文件中，并在文本文件中进行修改。在对文本文件进行更新后，从文本文件中导入新的 DBTUNE 表。

  1. Export the dbtune file before making any modifications.
    1. Start ArcCatalog.

    2. Click the ArcToolbox button ArcToolbox on the Standard toolbar.
    3. Expand Data Management Tools > Geodatabase Administration..
    4. Double-click Export Geodatabase Configuration Keywords.

      The Export Geodatabase Configuration Keywords dialog box appears.

    5. Click the browse folder for the Input Database Connection parameter and browse to the connection file for the enterprise geodatabase you want to export.
    6. Click the browse folder for the Output File parameter and browse to the path where the file will be exported.
    7. Name the file dbtune_exp.txt and click Save.
    8. Click OK on the Export Geodatabase Configuration Keywords dialog box.
  2. Modify the dbtune_logfile.txt ##LOGFILE_DEFAULTS configuration keyword in a text editor.
    ##LOGFILE_DEFAULTS
LD_INDEX_DATA_ID	"PCTFREE 0 INITRANS 4 TABLESPACE GDBLOGFILEIDX NOLOGGING "
LF_INDEXES	"PCTFREE 0 INITRANS 4 TABLESPACE GDBLOGFILEIDX NOLOGGING "
LF_STORAGE	"PCTFREE 0 INITRANS 4 TABLESPACE GDBLOGFILE"
SESSION_INDEX	"PCTFREE 0 INITRANS 4 TABLESPACE GDBLOGFILEIDX NOLOGGING "
SESSION_TEMP_TABLE	0
SESSION_STORAGE	"PCTFREE 0 INITRANS 4 TABLESPACE GDBLOGFILE"
LD_STORAGE	"PCTFREE 0 INITRANS 4 TABLESPACE GDBLOGFILE "
LD_INDEX_ROWID	"PCTFREE 0 INITRANS 4 TABLE PACE GDBLOGFILEIDX NOLOGGING "
END
  3. Import the modified dbtune_logfile.txt file using ArcCatalog or ArcMap.
    1. In the ArcToolbox expand Data Management Tools > Geodatabase Administration.
    2. Double-click Geodatabase Configuration Keywords.

      The Import Geodatabase Configuration Keywords dialog box appears.

    3. Click the browse folder next to the Input Database Connection parameter and browse to the enterprise geodatabase you want to import.
    4. Click the browse folder for the Input File parameter and browse to the path where the file will be imported.
    5. Name the file dbtune_logfile.txt and click Open.
    6. Click OK on the Import Geodatabase Configuration Keywords dialog box.

Creating log file tables

The geodatabase log files tables can be created in ArcMap by performing a large selection.

  1. Grant QUOTA permissions in OEM to the users on GDBLOGFILE and GDBLOGFILEIDX.
    ALTER USER SDE QUOTA UNLIMITED ON "SDELOGFILE";
ALTER USER SDE QUOTA UNLIMITED ON "SDELOGFILEIDX";

ALTER USER NIS QUOTA UNLIMITED ON "SDELOGFILE";
ALTER USER NIS QUOTA UNLIMITED ON "SDELOGFILEIDX";

ALTER USER NIS_EDITOR QUOTA UNLIMITED ON "SDELOGFILE";
ALTER USER NIS_EDITOR QUOTA UNLIMITED ON "SDELOGFILEIDX";

ALTER USER NIS_VIEWER QUOTA UNLIMITED ON "SDELOGFILE";
ALTER USER NIS_VIEWER QUOTA UNLIMITED ON "SDELOGFILEIDX";
  2. Grant CREATE TABLE and CREATE SEQUENCE permissions for the geodatabase editor/viewer users.
  3. 启动 ArcMap。
  4. 选择 100 多个要素。

    这将自动创建日志文件表。

  5. Remove CREATE TABLE and CREATE SEQUENCE permissions as appropriate.

相关主题