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 Sql Execution Plan resource in Oracle Cloud Infrastructure Database Management service. * * Retrieves a SQL execution plan for the SQL being tuned. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan({ * attribute: managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanAttribute, * managedDatabaseId: testManagedDatabase.id, * sqlObjectId: testObject.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOpcNamedCredentialId, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(args: GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs { /** * The attribute of the SQL execution plan. */ attribute: 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; /** * 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 getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult { /** * The text string identifying the type of execution plan. */ readonly attribute: string; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly managedDatabaseId: string; readonly opcNamedCredentialId?: string; /** * A SQL execution plan as a list of steps. */ readonly plans: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan[]; readonly sqlObjectId: string; readonly sqlTuningAdvisorTaskId: string; } /** * This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Sql Execution Plan resource in Oracle Cloud Infrastructure Database Management service. * * Retrieves a SQL execution plan for the SQL being tuned. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan({ * attribute: managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanAttribute, * managedDatabaseId: testManagedDatabase.id, * sqlObjectId: testObject.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOpcNamedCredentialId, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutputArgs { /** * The attribute of the SQL execution plan. */ attribute: 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; /** * 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=getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan.d.ts.map