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 Finding resource in Oracle Cloud Infrastructure Database Management service. * * Gets an array of the details of the findings that match specific filters. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksFinding = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksFinding({ * managedDatabaseId: testManagedDatabase.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * beginExecId: testBeginExec.id, * endExecId: testEndExec.id, * findingFilter: managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter, * indexHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter, * searchPeriod: managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod, * statsHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksFinding(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksFinding. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs { /** * The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. */ beginExecId?: string; /** * The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. */ endExecId?: string; /** * The filter used to display specific findings in the report. */ findingFilter?: string; /** * The hash value of the index table name. */ indexHashFilter?: string; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: string; /** * The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied. */ 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 hash value of the object for the statistic finding search. */ statsHashFilter?: string; } /** * A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksFinding. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksFindingResult { readonly beginExecId?: string; readonly endExecId?: string; readonly findingFilter?: string; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly indexHashFilter?: string; /** * An array of the findings for a tuning task. */ readonly items: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingItem[]; readonly managedDatabaseId: string; readonly searchPeriod?: string; /** * The unique identifier of the SQL Tuning Advisor task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ readonly sqlTuningAdvisorTaskId: string; readonly statsHashFilter?: string; } /** * This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Finding resource in Oracle Cloud Infrastructure Database Management service. * * Gets an array of the details of the findings that match specific filters. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksFinding = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksFinding({ * managedDatabaseId: testManagedDatabase.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * beginExecId: testBeginExec.id, * endExecId: testEndExec.id, * findingFilter: managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter, * indexHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter, * searchPeriod: managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod, * statsHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksFindingOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksFinding. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksFindingOutputArgs { /** * The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. */ beginExecId?: 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. */ endExecId?: pulumi.Input; /** * The filter used to display specific findings in the report. */ findingFilter?: pulumi.Input; /** * The hash value of the index table name. */ indexHashFilter?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied. */ 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 hash value of the object for the statistic finding search. */ statsHashFilter?: pulumi.Input; } //# sourceMappingURL=getManagedDatabaseSqlTuningAdvisorTasksFinding.d.ts.map