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 Recommendation resource in Oracle Cloud Infrastructure Database Management service. * * Gets the findings and possible actions for a given object in a SQL tuning task. * The task ID and object ID are used to retrieve the findings and recommendations. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksRecommendation = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation({ * executionId: testExecution.id, * managedDatabaseId: testManagedDatabase.id, * sqlObjectId: testObject.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksRecommendation(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendation. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs { /** * The execution ID for an execution of a SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ executionId: string; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: string; /** * The SQL object ID for the SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlObjectId: string; /** * The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlTuningAdvisorTaskId: string; } /** * A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksRecommendation. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult { readonly executionId: string; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; /** * A list of SQL Tuning Advisor recommendations. */ readonly items: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem[]; readonly managedDatabaseId: string; readonly sqlObjectId: string; /** * The unique identifier of the task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ readonly sqlTuningAdvisorTaskId: string; } /** * This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Recommendation resource in Oracle Cloud Infrastructure Database Management service. * * Gets the findings and possible actions for a given object in a SQL tuning task. * The task ID and object ID are used to retrieve the findings and recommendations. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksRecommendation = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation({ * executionId: testExecution.id, * managedDatabaseId: testManagedDatabase.id, * sqlObjectId: testObject.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksRecommendationOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendation. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs { /** * The execution ID for an execution of a SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ executionId: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * The SQL object ID for the SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlObjectId: 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; } //# sourceMappingURL=getManagedDatabaseSqlTuningAdvisorTasksRecommendation.d.ts.map