oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation
Explore with Pulumi AI
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
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testManagedDatabaseSqlTuningAdvisorTasksRecommendation = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation.Invoke(new()
{
ExecutionId = oci_database_management_execution.Test_execution.Id,
ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
SqlObjectId = oci_objectstorage_object.Test_object.Id,
SqlTuningAdvisorTaskId = oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
});
});
package main
import (
"github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs{
ExecutionId: oci_database_management_execution.Test_execution.Id,
ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.Id,
SqlObjectId: oci_objectstorage_object.Test_object.Id,
SqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
}, nil)
if err != nil {
return err
}
return nil
})
}
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var testManagedDatabaseSqlTuningAdvisorTasksRecommendation = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksRecommendation(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs.builder()
.executionId(oci_database_management_execution.test_execution().id())
.managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
.sqlObjectId(oci_objectstorage_object.test_object().id())
.sqlTuningAdvisorTaskId(oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task().id())
.build());
}
}
import pulumi
import pulumi_oci as oci
test_managed_database_sql_tuning_advisor_tasks_recommendation = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_recommendation(execution_id=oci_database_management_execution["test_execution"]["id"],
managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
sql_object_id=oci_objectstorage_object["test_object"]["id"],
sql_tuning_advisor_task_id=oci_database_management_sql_tuning_advisor_task["test_sql_tuning_advisor_task"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testManagedDatabaseSqlTuningAdvisorTasksRecommendation = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation({
executionId: oci_database_management_execution.test_execution.id,
managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
sqlObjectId: oci_objectstorage_object.test_object.id,
sqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id,
});
variables:
testManagedDatabaseSqlTuningAdvisorTasksRecommendation:
fn::invoke:
Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksRecommendation
Arguments:
executionId: ${oci_database_management_execution.test_execution.id}
managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
sqlObjectId: ${oci_objectstorage_object.test_object.id}
sqlTuningAdvisorTaskId: ${oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id}
Using getManagedDatabaseSqlTuningAdvisorTasksRecommendation
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getManagedDatabaseSqlTuningAdvisorTasksRecommendation(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult>
function getManagedDatabaseSqlTuningAdvisorTasksRecommendationOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult>
def get_managed_database_sql_tuning_advisor_tasks_recommendation(execution_id: Optional[str] = None,
managed_database_id: Optional[str] = None,
sql_object_id: Optional[str] = None,
sql_tuning_advisor_task_id: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult
def get_managed_database_sql_tuning_advisor_tasks_recommendation_output(execution_id: Optional[pulumi.Input[str]] = None,
managed_database_id: Optional[pulumi.Input[str]] = None,
sql_object_id: Optional[pulumi.Input[str]] = None,
sql_tuning_advisor_task_id: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult]
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput
> Note: This function is named GetManagedDatabaseSqlTuningAdvisorTasksRecommendation
in the Go SDK.
public static class GetManagedDatabaseSqlTuningAdvisorTasksRecommendation
{
public static Task<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs args, InvokeOptions? opts = null)
public static Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult> getManagedDatabaseSqlTuningAdvisorTasksRecommendation(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksRecommendation:getManagedDatabaseSqlTuningAdvisorTasksRecommendation
arguments:
# arguments dictionary
The following arguments are supported:
- Execution
Id string The execution ID for an execution of a SQL tuning task. This is not the OCID.
- Managed
Database stringId The OCID of the Managed Database.
- Sql
Object stringId The SQL object ID for the SQL tuning task. This is not the OCID.
- Sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- Execution
Id string The execution ID for an execution of a SQL tuning task. This is not the OCID.
- Managed
Database stringId The OCID of the Managed Database.
- Sql
Object stringId The SQL object ID for the SQL tuning task. This is not the OCID.
- Sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- execution
Id String The execution ID for an execution of a SQL tuning task. This is not the OCID.
- managed
Database StringId The OCID of the Managed Database.
- sql
Object StringId The SQL object ID for the SQL tuning task. This is not the OCID.
- sql
Tuning StringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- execution
Id string The execution ID for an execution of a SQL tuning task. This is not the OCID.
- managed
Database stringId The OCID of the Managed Database.
- sql
Object stringId The SQL object ID for the SQL tuning task. This is not the OCID.
- sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- execution_
id str The execution ID for an execution of a SQL tuning task. This is not the OCID.
- managed_
database_ strid The OCID of the Managed Database.
- sql_
object_ strid The SQL object ID for the SQL tuning task. This is not the OCID.
- sql_
tuning_ stradvisor_ task_ id The SQL tuning task identifier. This is not the OCID.
- execution
Id String The execution ID for an execution of a SQL tuning task. This is not the OCID.
- managed
Database StringId The OCID of the Managed Database.
- sql
Object StringId The SQL object ID for the SQL tuning task. This is not the OCID.
- sql
Tuning StringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
getManagedDatabaseSqlTuningAdvisorTasksRecommendation Result
The following output properties are available:
- Execution
Id string - Id string
The provider-assigned unique ID for this managed resource.
- Items
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendation Item> A list of SQL Tuning Advisor recommendations.
- Managed
Database stringId - Sql
Object stringId - Sql
Tuning stringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- Execution
Id string - Id string
The provider-assigned unique ID for this managed resource.
- Items
[]Get
Managed Database Sql Tuning Advisor Tasks Recommendation Item A list of SQL Tuning Advisor recommendations.
- Managed
Database stringId - Sql
Object stringId - Sql
Tuning stringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- execution
Id String - id String
The provider-assigned unique ID for this managed resource.
- items
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendation Item> A list of SQL Tuning Advisor recommendations.
- managed
Database StringId - sql
Object StringId - sql
Tuning StringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- execution
Id string - id string
The provider-assigned unique ID for this managed resource.
- items
Get
Managed Database Sql Tuning Advisor Tasks Recommendation Item[] A list of SQL Tuning Advisor recommendations.
- managed
Database stringId - sql
Object stringId - sql
Tuning stringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- execution_
id str - id str
The provider-assigned unique ID for this managed resource.
- items
Get
Managed Database Sql Tuning Advisor Tasks Recommendation Item] A list of SQL Tuning Advisor recommendations.
- managed_
database_ strid - sql_
object_ strid - sql_
tuning_ stradvisor_ task_ id The unique identifier of the task. This is not the OCID.
- execution
Id String - id String
The provider-assigned unique ID for this managed resource.
- items List<Property Map>
A list of SQL Tuning Advisor recommendations.
- managed
Database StringId - sql
Object StringId - sql
Tuning StringAdvisor Task Id The unique identifier of the task. This is not the OCID.
Supporting Types
GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem
- Benefit double
The percentage benefit of this implementation.
- Finding string
Summary of the issue found in the SQL statement.
- Implement
Action stringSql Action sql to be implemented based on the recommendation result.
- Is
Parallel boolExecution Indicates whether a SQL Profile recommendation uses parallel execution.
- Rationale string
Describes the reasoning behind the recommendation and how it relates to the finding.
- Recommendation string
The recommendation for a specific finding.
- Recommendation
Key int The unique identifier of the recommendation in the scope of the task.
- Recommendation
Type string Type of recommendation.
- Sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- Sql
Tuning stringAdvisor Task Object Id The key of the object to which these recommendations apply. This is not the OCID.
- Benefit float64
The percentage benefit of this implementation.
- Finding string
Summary of the issue found in the SQL statement.
- Implement
Action stringSql Action sql to be implemented based on the recommendation result.
- Is
Parallel boolExecution Indicates whether a SQL Profile recommendation uses parallel execution.
- Rationale string
Describes the reasoning behind the recommendation and how it relates to the finding.
- Recommendation string
The recommendation for a specific finding.
- Recommendation
Key int The unique identifier of the recommendation in the scope of the task.
- Recommendation
Type string Type of recommendation.
- Sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- Sql
Tuning stringAdvisor Task Object Id The key of the object to which these recommendations apply. This is not the OCID.
- benefit Double
The percentage benefit of this implementation.
- finding String
Summary of the issue found in the SQL statement.
- implement
Action StringSql Action sql to be implemented based on the recommendation result.
- is
Parallel BooleanExecution Indicates whether a SQL Profile recommendation uses parallel execution.
- rationale String
Describes the reasoning behind the recommendation and how it relates to the finding.
- recommendation String
The recommendation for a specific finding.
- recommendation
Key Integer The unique identifier of the recommendation in the scope of the task.
- recommendation
Type String Type of recommendation.
- sql
Tuning StringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- sql
Tuning StringAdvisor Task Object Id The key of the object to which these recommendations apply. This is not the OCID.
- benefit number
The percentage benefit of this implementation.
- finding string
Summary of the issue found in the SQL statement.
- implement
Action stringSql Action sql to be implemented based on the recommendation result.
- is
Parallel booleanExecution Indicates whether a SQL Profile recommendation uses parallel execution.
- rationale string
Describes the reasoning behind the recommendation and how it relates to the finding.
- recommendation string
The recommendation for a specific finding.
- recommendation
Key number The unique identifier of the recommendation in the scope of the task.
- recommendation
Type string Type of recommendation.
- sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- sql
Tuning stringAdvisor Task Object Id The key of the object to which these recommendations apply. This is not the OCID.
- benefit float
The percentage benefit of this implementation.
- finding str
Summary of the issue found in the SQL statement.
- implement_
action_ strsql Action sql to be implemented based on the recommendation result.
- is_
parallel_ boolexecution Indicates whether a SQL Profile recommendation uses parallel execution.
- rationale str
Describes the reasoning behind the recommendation and how it relates to the finding.
- recommendation str
The recommendation for a specific finding.
- recommendation_
key int The unique identifier of the recommendation in the scope of the task.
- recommendation_
type str Type of recommendation.
- sql_
tuning_ stradvisor_ task_ id The SQL tuning task identifier. This is not the OCID.
- sql_
tuning_ stradvisor_ task_ object_ id The key of the object to which these recommendations apply. This is not the OCID.
- benefit Number
The percentage benefit of this implementation.
- finding String
Summary of the issue found in the SQL statement.
- implement
Action StringSql Action sql to be implemented based on the recommendation result.
- is
Parallel BooleanExecution Indicates whether a SQL Profile recommendation uses parallel execution.
- rationale String
Describes the reasoning behind the recommendation and how it relates to the finding.
- recommendation String
The recommendation for a specific finding.
- recommendation
Key Number The unique identifier of the recommendation in the scope of the task.
- recommendation
Type String Type of recommendation.
- sql
Tuning StringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- sql
Tuning StringAdvisor Task Object Id The key of the object to which these recommendations apply. This is not the OCID.
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.