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 Sql Tuning Advisor Tasks Recommendations 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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations({ * executionId: testExecution.id, * managedDatabaseId: testManagedDatabase.id, * sqlObjectId: testObject.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksRecommendations(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendations. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs { /** * 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; filters?: inputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter[]; /** * 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; /** * 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 getManagedDatabaseSqlTuningAdvisorTasksRecommendations. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult { readonly executionId: string; readonly filters?: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter[]; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly managedDatabaseId: string; readonly opcNamedCredentialId?: 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; /** * The list of sql_tuning_advisor_task_recommendation_collection. */ readonly sqlTuningAdvisorTaskRecommendationCollections: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection[]; } /** * This data source provides the list of Managed Database Sql Tuning Advisor Tasks Recommendations 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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations({ * executionId: testExecution.id, * managedDatabaseId: testManagedDatabase.id, * sqlObjectId: testObject.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendations. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs { /** * 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; 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 OCID of the Named Credential. */ opcNamedCredentialId?: 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=getManagedDatabaseSqlTuningAdvisorTasksRecommendations.d.ts.map