getDataSourceStatisticsConfig
Get the cost-based optimizer (CBO) statistics configuration for a data source.
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.
Response Elements
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; sets 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.
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.