Oracle Cloud Infrastructure
getManagedDatabaseSqlTuningAdvisorTasksRecommendations
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
using Pulumi;
using Oci = Pulumi.Oci;
class MyStack : Stack
{
public MyStack()
{
var testManagedDatabaseSqlTuningAdvisorTasksRecommendations = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendations.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs
{
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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs{
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
})
}
Coming soon!
import pulumi
import pulumi_oci as oci
test_managed_database_sql_tuning_advisor_tasks_recommendations = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_recommendations(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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations({
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,
});
Coming soon!
Using getManagedDatabaseSqlTuningAdvisorTasksRecommendations
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 getManagedDatabaseSqlTuningAdvisorTasksRecommendations(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult>
function getManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult>
def get_managed_database_sql_tuning_advisor_tasks_recommendations(execution_id: Optional[str] = None,
filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter]] = 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) -> GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult
def get_managed_database_sql_tuning_advisor_tasks_recommendations_output(execution_id: Optional[pulumi.Input[str]] = None,
filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilterArgs]]]] = 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[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult]
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput
> Note: This function is named GetManagedDatabaseSqlTuningAdvisorTasksRecommendations
in the Go SDK.
public static class GetManagedDatabaseSqlTuningAdvisorTasksRecommendations
{
public static Task<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs args, InvokeOptions? opts = null)
public static Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> getManagedDatabaseSqlTuningAdvisorTasksRecommendations(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
Function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksRecommendations:getManagedDatabaseSqlTuningAdvisorTasksRecommendations
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.
- Filters
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter>
- 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.
- Filters
[]Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter
- 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.
- filters
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter>
- 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.
- filters
Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter[]
- 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.
- filters
Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter]
- 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.
- filters List<Property Map>
getManagedDatabaseSqlTuningAdvisorTasksRecommendations Result
The following output properties are available:
- Execution
Id string - Id string
The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Sql
Object stringId - Sql
Tuning stringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- Sql
Tuning List<GetAdvisor Task Recommendation Collections Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection> The list of sql_tuning_advisor_task_recommendation_collection.
- Filters
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter>
- Execution
Id string - Id string
The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Sql
Object stringId - Sql
Tuning stringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- Sql
Tuning []GetAdvisor Task Recommendation Collections Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection The list of sql_tuning_advisor_task_recommendation_collection.
- Filters
[]Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter
- execution
Id String - id String
The provider-assigned unique ID for this managed resource.
- managed
Database StringId - sql
Object StringId - sql
Tuning StringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- sql
Tuning List<GetAdvisor Task Recommendation Collections Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection> The list of sql_tuning_advisor_task_recommendation_collection.
- filters
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter>
- execution
Id string - id string
The provider-assigned unique ID for this managed resource.
- managed
Database stringId - sql
Object stringId - sql
Tuning stringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- sql
Tuning GetAdvisor Task Recommendation Collections Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection[] The list of sql_tuning_advisor_task_recommendation_collection.
- filters
Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter[]
- execution_
id str - id str
The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - sql_
object_ strid - sql_
tuning_ stradvisor_ task_ id The unique identifier of the task. This is not the OCID.
- sql_
tuning_ Getadvisor_ task_ recommendation_ collections Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection] The list of sql_tuning_advisor_task_recommendation_collection.
- filters
Get
Managed Database Sql Tuning Advisor Tasks Recommendations Filter]
- execution
Id String - id String
The provider-assigned unique ID for this managed resource.
- managed
Database StringId - sql
Object StringId - sql
Tuning StringAdvisor Task Id The unique identifier of the task. This is not the OCID.
- sql
Tuning List<Property Map>Advisor Task Recommendation Collections The list of sql_tuning_advisor_task_recommendation_collection.
- filters List<Property Map>
Supporting Types
GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter
GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection
- Items
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection Item> A list of SQL Tuning Advisor recommendations.
- Items
[]Get
Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection Item A list of SQL Tuning Advisor recommendations.
- items
List<Get
Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection Item> A list of SQL Tuning Advisor recommendations.
- items
Get
Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection Item[] A list of SQL Tuning Advisor recommendations.
- items
Get
Managed Database Sql Tuning Advisor Tasks Recommendations Sql Tuning Advisor Task Recommendation Collection Item] A list of SQL Tuning Advisor recommendations.
- items List<Property Map>
A list of SQL Tuning Advisor recommendations.
GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
- https://github.com/pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.