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 Advisor Executions in Oracle Cloud Infrastructure Database Management service. * * Lists the details of the Optimizer Statistics Advisor task executions, such as their duration, and the number of findings, if any. * Optionally, you can specify a date-time range (of seven days) to obtain the list of executions that fall within the specified time range. * If the date-time range is not specified, then the executions in the last seven days are listed. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseOptimizerStatisticsAdvisorExecutions = oci.databasemanagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutions({ * managedDatabaseId: testManagedDatabase.id, * endTimeLessThanOrEqualTo: managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo, * startTimeGreaterThanOrEqualTo: managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo, * }); * ``` */ export declare function getManagedDatabaseOptimizerStatisticsAdvisorExecutions(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseOptimizerStatisticsAdvisorExecutions. */ export interface GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs { /** * 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.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter[]; /** * 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; } /** * A collection of values returned by getManagedDatabaseOptimizerStatisticsAdvisorExecutions. */ export interface GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult { readonly endTimeLessThanOrEqualTo?: string; readonly filters?: outputs.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter[]; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly managedDatabaseId: string; /** * The list of optimizer_statistics_advisor_executions_collection. */ readonly optimizerStatisticsAdvisorExecutionsCollections: outputs.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection[]; readonly startTimeGreaterThanOrEqualTo?: string; } /** * This data source provides the list of Managed Database Optimizer Statistics Advisor Executions in Oracle Cloud Infrastructure Database Management service. * * Lists the details of the Optimizer Statistics Advisor task executions, such as their duration, and the number of findings, if any. * Optionally, you can specify a date-time range (of seven days) to obtain the list of executions that fall within the specified time range. * If the date-time range is not specified, then the executions in the last seven days are listed. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseOptimizerStatisticsAdvisorExecutions = oci.databasemanagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutions({ * managedDatabaseId: testManagedDatabase.id, * endTimeLessThanOrEqualTo: managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo, * startTimeGreaterThanOrEqualTo: managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo, * }); * ``` */ export declare function getManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutput(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseOptimizerStatisticsAdvisorExecutions. */ export interface GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutputArgs { /** * 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 [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; } //# sourceMappingURL=getManagedDatabaseOptimizerStatisticsAdvisorExecutions.d.ts.map