import * as pulumi from "@pulumi/pulumi"; import * as outputs from "../types/output"; /** * This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Summary Report resource in Oracle Cloud Infrastructure Database Management service. * * Gets the summary report for the specified SQL Tuning Advisor task. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport({ * managedDatabaseId: testManagedDatabase.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * beginExecIdGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo, * endExecIdLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId, * searchPeriod: managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod, * timeGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo, * timeLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksSummaryReport(args: GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksSummaryReport. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs { /** * The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. */ beginExecIdGreaterThanOrEqualTo?: string; /** * The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. */ endExecIdLessThanOrEqualTo?: string; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: string; /** * The OCID of the Named Credential. */ opcNamedCredentialId?: string; /** * How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks. */ searchPeriod?: string; /** * The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlTuningAdvisorTaskId: string; /** * The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. */ timeGreaterThanOrEqualTo?: string; /** * The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. */ timeLessThanOrEqualTo?: string; } /** * A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksSummaryReport. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult { readonly beginExecIdGreaterThanOrEqualTo?: string; readonly endExecIdLessThanOrEqualTo?: string; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; /** * The list of object findings related to indexes. */ readonly indexFindings: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding[]; readonly managedDatabaseId: string; /** * The list of object findings related to statistics. */ readonly objectStatFindings: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding[]; readonly opcNamedCredentialId?: string; readonly searchPeriod?: string; readonly sqlTuningAdvisorTaskId: string; /** * The number of distinct SQL statements with stale or missing optimizer statistics recommendations. */ readonly statistics: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic[]; /** * The general information regarding the SQL Tuning Advisor task. */ readonly taskInfos: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo[]; readonly timeGreaterThanOrEqualTo?: string; readonly timeLessThanOrEqualTo?: string; } /** * This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Summary Report resource in Oracle Cloud Infrastructure Database Management service. * * Gets the summary report for the specified SQL Tuning Advisor task. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport({ * managedDatabaseId: testManagedDatabase.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * beginExecIdGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo, * endExecIdLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId, * searchPeriod: managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod, * timeGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo, * timeLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksSummaryReport. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutputArgs { /** * The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. */ beginExecIdGreaterThanOrEqualTo?: pulumi.Input; /** * The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. */ endExecIdLessThanOrEqualTo?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * The OCID of the Named Credential. */ opcNamedCredentialId?: pulumi.Input; /** * How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks. */ searchPeriod?: pulumi.Input; /** * The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlTuningAdvisorTaskId: pulumi.Input; /** * The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. */ timeGreaterThanOrEqualTo?: pulumi.Input; /** * The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. */ timeLessThanOrEqualTo?: pulumi.Input; } //# sourceMappingURL=getManagedDatabaseSqlTuningAdvisorTasksSummaryReport.d.ts.map