updateDataSourceStatisticsConfig
Update the Cost Based Optimizer (CBO) statistics configuration for a data source. See
getDataSourceStatisticsConfig for more information.
Location
/services/webservices/system/admin/resource/operations/
Request Elements
path: The path of a resource.
type: The type of the resource. May only be a relational physical DATA_SOURCE.
detail: The level of detail about the resources to include in the response. Valid values are NONE, SIMPLE, and FULL.
• dataSourceStatisticsConfig: 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. Can be used to temporarily disable CBO.
• tableGatherDefault (optional): Unless overridden at table level, sets the default table configuration. Values are ALL, COLUMN_BOUNDARY, NONE or TABLE_BOUNDARY.
• numThreads (optional): Integer 1 to N; indicates how many threads should be allocated to gather statistics for this data source.
• maxTime (optional): Integer 0 to n in minutes. Data source level default for maximum amount of time the process should spend gathering data for each table; 0 means no limit.
• refresh (optional): How the statistics data should be refreshed. See
Refresh Element.
Response Elements
dataSourceStatisticsConfig: Same structure as request elements if request detail is not NONE; otherwise empty.
Faults
IllegalArgument: If the path is malformed or an illegal type is provided.
NotAllowed: If the resource is not of the write 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 other than the last one.
Security: If the user does not have WRITE access on the last item in path.
Security: If the user does not have the ACCESS_TOOLS right.