Analyze Datasets, Change Privileges, Compress and Configure Geodatabase Log File Tables Tools
Analyze Datasets
How to Analyze Datasets Tool in ArcToolbox ArcMap ArcGIS??
 |
| Analyze Datasets |
Path to access the tool
:
Analyze Datasets Tool,
Geodatabase
Administration Toolset, Data Management Tools
Toolbox
Analyze Datasets
Updates database
statistics of base tables, delta tables, and archive tables,
along with the
statistics on those tables' indexes. This tool is used in enterprise
geodatabases to help get optimal performance from the RDBMS's query optimizer.
Stale statistics can lead to poor geodatabase performance.
1. Input Database Connection
The enterprise database
that contains the data to be analyzed.
2. Include System Tables
Indicates whether statistics will be gathered on the states and state lineages tables.
- Unchecked—Statistics will not be gathered on the states and state lineages tables. This is the default.
- Checked—Statistics will be gathered on the states and state lineages tables.
You must be the geodatabase administrator for this option to be
activated.
This option only applies to geodatabases. If the input workspace
is a database, this option will be disabled.
3. Datasets to Analyze (optional)
Names of the datasets
that will be analyzed. Only datasets that are owned by the connected user will
be displayed.
4. Analyze Base Tables for Selected Dataset(s) (optional)
Indicates whether the
selected dataset base tables will be analyzed.
This option only applies to geodatabases. If the input workspace is a database, this option will be disabled.
- Checked—Statistics will be gathered on the base tables for the selected datasets. This is the default.
- Unchecked—Statistics will not be gathered for the base tables for the selected datasets.
5. Analyze Delta Tables for Selected Dataset(s) (optional)
Indicates whether the
selected dataset delta tables will be analyzed.
This option only applies to geodatabases. If the input workspace is a database, this option will be disabled.
- Checked—Statistics will be gathered on the delta tables for the selected datasets. This is the default.
- Unchecked—Statistics will not be gathered for the delta tables for the selected datasets.
6. Analyze Archive Tables for Selected Dataset(s) (optional)
Indicates whether the
selected dataset archive tables will be analyzed.
This option only applies to geodatabases. If the input workspace is a database, this option will always be disabled.
- Checked—Statistics will be gathered on the archive tables for the selected datasets. This is the default.
- Unchecked—Statistics will not be gathered for the archive tables for the selected datasets.
Change Privileges
How to Change Privileges Tool in ArcToolbox ArcMap ArcGIS??
 |
| Change Privileges |
Path to access the tool
:
Change Privileges Tool,
Geodatabase
Administration Toolset,
Data Management Tools
Toolbox
Change Privileges
Establishes or changes
user access privileges to the input enterprise database datasets, stand-alone
feature classes, or tables.
1. Input Dataset
The datasets, feature
classes, or tables whose access privileges will be changed.
2. User
The database user name
whose privileges are being modified.
3. View (Select) (optional)
Establishes the user's view privileges.
- AS_IS —No change to the user's existing view privilege. If the user has view privileges, they will continue to have view privileges. If the user doesn't have view privileges, they will continue to not have view privileges.
- GRANT—Allows user to view datasets.
- REVOKE—Removes all user privileges to view datasets.
4. Edit (Update/Insert/Delete) (optional)
Establishes the user's edit privileges.
- AS_IS — No change to the user's existing edit privilege. If the user has edit privileges, they will continue to have edit privileges. If the user doesn't have edit privileges, they will continue to not have edit privileges. This is the default.
- GRANT—Allows the user to edit the input datasets.
- REVOKE—Removes the user's edit privileges. The user may still view the input dataset.
Compress
How to Compress Tool in ArcToolbox ArcMap ArcGIS??
 |
| Compress Tool |
Path to access the tool
:
Compress Tool,
Geodatabase Administration
Toolset, Data Management Tools
Toolbox
Compress
Compresses an enterprise
geodatabase by removing states not referenced by a version and redundant rows.
1. Input Database Connection
The database connection
file that connects to the enterprise geodatabase to be compressed. Connect as
the geodatabase administrator.
Configure Geodatabase Log File Tables
How to Configure Geodatabase Log File Tables Tool in ArcToolbox ArcMap ArcGIS??
 |
| Configure Geodatabase Log File Tables |
Path to access the tool
:
Configure Geodatabase Log File
Tables Tool, Geodatabase
Administration Toolset, Data Management Tools
Toolbox
Configure Geodatabase Log File
Tables
Alters the type of log
file tables used by an enterprise geodatabase to maintain lists of records
cached by ArcGIS.
1. Input Database Connection
Provide a database
connection (.sde file) to the enterprise geodatabase for which you want to
change the log file table configuration. The connection must be made as the
geodatabase administrator.
2. Log File Type
Specify the type of log file tables you want the geodatabase to use.
- SESSION_LOG_FILE—Use session-based log file tables for selection sets. Session-based log file tables are dedicated to a single session and may contain multiple selection sets.
- SHARED_LOG_FILE—Use shared log file tables for selection sets. Shared log file tables are shared by all sessions that connect as the same user.
3. Number of session based log file tables to be owned in a pool by the administrator (optional)
If you want the
geodatabase to use a pool of session-based log file tables owned by the
geodatabase administrator, specify the number of tables you want included in
the pool.
4. Create session based log files tables owned by each user in the TempDB database (SQL Server only) (optional)
This parameter is no longer applicable, starting with the ArcGIS 10.5 and ArcGIS Pro 1.4 releases.
Comments
Post a Comment