import * as pulumi from "@pulumi/pulumi"; import * as inputs from "../types/input"; import * as outputs from "../types/output"; /** * This data source provides the list of Managed Database Optimizer Statistics Collection Aggregations in Oracle Cloud Infrastructure Database Management service. * * Gets a list of the optimizer statistics collection operations per hour, grouped by task or object status for the specified Managed Database. * You must specify a value for the GroupByQueryParam to determine whether the data should be grouped by task status or task object status. * Optionally, you can specify a date-time range (of seven days) to obtain collection aggregations within the specified time range. * If the date-time range is not specified, then the operations in the last seven days are listed. * You can further filter the results by providing the optional type of TaskTypeQueryParam. * If the task type if not provided, then both Auto and Manual tasks are considered for aggregation. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseOptimizerStatisticsCollectionAggregations = oci.databasemanagement.getManagedDatabaseOptimizerStatisticsCollectionAggregations({ * groupType: managedDatabaseOptimizerStatisticsCollectionAggregationGroupType, * managedDatabaseId: testManagedDatabase.id, * endTimeLessThanOrEqualTo: managedDatabaseOptimizerStatisticsCollectionAggregationEndTimeLessThanOrEqualTo, * startTimeGreaterThanOrEqualTo: managedDatabaseOptimizerStatisticsCollectionAggregationStartTimeGreaterThanOrEqualTo, * taskType: managedDatabaseOptimizerStatisticsCollectionAggregationTaskType, * }); * ``` */ export declare function getManagedDatabaseOptimizerStatisticsCollectionAggregations(args: GetManagedDatabaseOptimizerStatisticsCollectionAggregationsArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseOptimizerStatisticsCollectionAggregations. */ export interface GetManagedDatabaseOptimizerStatisticsCollectionAggregationsArgs { /** * The end time of the time range to retrieve the optimizer statistics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". */ endTimeLessThanOrEqualTo?: string; filters?: inputs.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionAggregationsFilter[]; /** * The optimizer statistics tasks grouped by type. */ groupType: string; limit?: number; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: string; /** * The start time of the time range to retrieve the optimizer statistics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". */ startTimeGreaterThanOrEqualTo?: string; /** * The filter types of the optimizer statistics tasks. */ taskType?: string; } /** * A collection of values returned by getManagedDatabaseOptimizerStatisticsCollectionAggregations. */ export interface GetManagedDatabaseOptimizerStatisticsCollectionAggregationsResult { readonly endTimeLessThanOrEqualTo?: string; readonly filters?: outputs.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionAggregationsFilter[]; readonly groupType: string; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly limit?: number; readonly managedDatabaseId: string; /** * The list of optimizer_statistics_collection_aggregations_collection. */ readonly optimizerStatisticsCollectionAggregationsCollections: outputs.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionAggregationsOptimizerStatisticsCollectionAggregationsCollection[]; readonly startTimeGreaterThanOrEqualTo?: string; readonly taskType?: string; } /** * This data source provides the list of Managed Database Optimizer Statistics Collection Aggregations in Oracle Cloud Infrastructure Database Management service. * * Gets a list of the optimizer statistics collection operations per hour, grouped by task or object status for the specified Managed Database. * You must specify a value for the GroupByQueryParam to determine whether the data should be grouped by task status or task object status. * Optionally, you can specify a date-time range (of seven days) to obtain collection aggregations within the specified time range. * If the date-time range is not specified, then the operations in the last seven days are listed. * You can further filter the results by providing the optional type of TaskTypeQueryParam. * If the task type if not provided, then both Auto and Manual tasks are considered for aggregation. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseOptimizerStatisticsCollectionAggregations = oci.databasemanagement.getManagedDatabaseOptimizerStatisticsCollectionAggregations({ * groupType: managedDatabaseOptimizerStatisticsCollectionAggregationGroupType, * managedDatabaseId: testManagedDatabase.id, * endTimeLessThanOrEqualTo: managedDatabaseOptimizerStatisticsCollectionAggregationEndTimeLessThanOrEqualTo, * startTimeGreaterThanOrEqualTo: managedDatabaseOptimizerStatisticsCollectionAggregationStartTimeGreaterThanOrEqualTo, * taskType: managedDatabaseOptimizerStatisticsCollectionAggregationTaskType, * }); * ``` */ export declare function getManagedDatabaseOptimizerStatisticsCollectionAggregationsOutput(args: GetManagedDatabaseOptimizerStatisticsCollectionAggregationsOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseOptimizerStatisticsCollectionAggregations. */ export interface GetManagedDatabaseOptimizerStatisticsCollectionAggregationsOutputArgs { /** * The end time of the time range to retrieve the optimizer statistics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". */ endTimeLessThanOrEqualTo?: pulumi.Input; filters?: pulumi.Input[] | undefined>; /** * The optimizer statistics tasks grouped by type. */ groupType: pulumi.Input; limit?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * The start time of the time range to retrieve the optimizer statistics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". */ startTimeGreaterThanOrEqualTo?: pulumi.Input; /** * The filter types of the optimizer statistics tasks. */ taskType?: pulumi.Input; } //# sourceMappingURL=getManagedDatabaseOptimizerStatisticsCollectionAggregations.d.ts.map