updateCachedResourceStatisticsConfig
Set the cost based optimizer (CBO) statistics configuration for a data source. Cache must be configured before configuring statistics.
Location
/services/webservices/system/admin/resource/operations/
Request Elements
path: The path of a cacheable resource.
type: Cached resource statistics are of type TABLE.
detail: The level of detail about the resources to include in the response. Valid values are NONE, SIMPLE, and FULL.
cachedStatisticsConfig: The statistics configuration of the given resource.
• configured (optional): TRUE if statistics gathering is configured; otherwise FALSE.
• useEnabled (optional): TRUE if gathered statistics are to be used by CBO; otherwise FALSE. This can be used to temporarily disable CBO.
• cardinalityMin (optional): Minimum cardinality for this resource. Setting this value overrides gathered statistics.
• cardinalityMax (optional): Maximum cardinality for this resource. Setting this value overrides gathered statistics.
• cardinalityExpected (optional): Expected cardinality for this resource. Setting this value overrides gathered statistics.
• gatherEnabled (optional): Defines what statistics should be gathered for this resource. Valid values are TABLE_BOUNDARY or CUSTOM.
• maxTime (optional): Integer 0 to n in minutes. Maximum amount of time the process should spend gathering data; 0 means no limit
• columns (optional): Only applicable if gatherEnabled is set to CUSTOM.
• column (optional): List indicating what specific data to get for each column:
name: Simple column name.
flags: Valid values are NONE, BOUNDARY or ALL.
• onCacheRefresh (optional): TRUE if statistics gathering should be automatically triggered by cache refresh. If FALSE, refresh mode can be specified.
• refresh (optional): How the statistics data should be refreshed.
• mode: How the statistics data should be refreshed (MANUAL or SCHEDULED).
Response Elements
cachedStatisticsConfig (optional): The statistics configuration of the given resource. This element is only present in the response if the detail level is not NONE.
Faults
IllegalArgument: If the path is malformed or an illegal type is provided.
NotAllowed: If the resource is of the wrong type.
NotFound: If the resource or any portion of the path to the resource does not exist.
Security: If the user does not have READ access on all items in path.
Security: If the user does not have the ACCESS_TOOLS right.