Oracle Cloud Infrastructure

Pulumi Official

Package maintained by Pulumi

v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan

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

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs
        {
            Attribute = @var.Managed_database_sql_tuning_advisor_tasks_sql_execution_plan_attribute,
            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.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs{
			Attribute:              _var.Managed_database_sql_tuning_advisor_tasks_sql_execution_plan_attribute,
			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_sql_execution_plan = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_sql_execution_plan(attribute=var["managed_database_sql_tuning_advisor_tasks_sql_execution_plan_attribute"],
    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 testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan({
    attribute: _var.managed_database_sql_tuning_advisor_tasks_sql_execution_plan_attribute,
    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 getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan

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 getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(args: GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult>
function getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult>

def get_managed_database_sql_tuning_advisor_tasks_sql_execution_plan(attribute: 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) -> GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult
def get_managed_database_sql_tuning_advisor_tasks_sql_execution_plan_output(attribute: 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[GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult]

func GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResultOutput

> Note: This function is named GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan in the Go SDK.

public static class GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan 
{
    public static Task<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult> getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan:getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan
  Arguments:
    # Arguments dictionary

The following arguments are supported:

Attribute string: The attribute of the SQL execution plan.
ManagedDatabaseId string: The OCID of the Managed Database.
SqlObjectId string: The SQL object ID for the SQL tuning task. This is not the OCID.
SqlTuningAdvisorTaskId string: The SQL tuning task identifier. This is not the OCID.

Attribute string: The attribute of the SQL execution plan.
ManagedDatabaseId string: The OCID of the Managed Database.
SqlObjectId string: The SQL object ID for the SQL tuning task. This is not the OCID.
SqlTuningAdvisorTaskId string: The SQL tuning task identifier. This is not the OCID.

attribute String: The attribute of the SQL execution plan.
managedDatabaseId String: The OCID of the Managed Database.
sqlObjectId String: The SQL object ID for the SQL tuning task. This is not the OCID.
sqlTuningAdvisorTaskId String: The SQL tuning task identifier. This is not the OCID.

attribute string: The attribute of the SQL execution plan.
managedDatabaseId string: The OCID of the Managed Database.
sqlObjectId string: The SQL object ID for the SQL tuning task. This is not the OCID.
sqlTuningAdvisorTaskId string: The SQL tuning task identifier. This is not the OCID.

attribute str: The attribute of the SQL execution plan.
managed_database_id str: The OCID of the Managed Database.
sql_object_id str: The SQL object ID for the SQL tuning task. This is not the OCID.
sql_tuning_advisor_task_id str: The SQL tuning task identifier. This is not the OCID.

attribute String: The attribute of the SQL execution plan.
managedDatabaseId String: The OCID of the Managed Database.
sqlObjectId String: The SQL object ID for the SQL tuning task. This is not the OCID.
sqlTuningAdvisorTaskId String: The SQL tuning task identifier. This is not the OCID.

getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan Result

The following output properties are available:

Attribute string: The text string identifying the type of execution plan.
Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
Plans List<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan>: A SQL execution plan as a list of steps.
SqlObjectId string
SqlTuningAdvisorTaskId string

Attribute string: The text string identifying the type of execution plan.
Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
Plans []GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan: A SQL execution plan as a list of steps.
SqlObjectId string
SqlTuningAdvisorTaskId string

attribute String: The text string identifying the type of execution plan.
id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
plans List<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan>: A SQL execution plan as a list of steps.
sqlObjectId String
sqlTuningAdvisorTaskId String

attribute string: The text string identifying the type of execution plan.
id string: The provider-assigned unique ID for this managed resource.
managedDatabaseId string
plans GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan[]: A SQL execution plan as a list of steps.
sqlObjectId string
sqlTuningAdvisorTaskId string

attribute str: The text string identifying the type of execution plan.
id str: The provider-assigned unique ID for this managed resource.
managed_database_id str
plans GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan]: A SQL execution plan as a list of steps.
sql_object_id str
sql_tuning_advisor_task_id str

attribute String: The text string identifying the type of execution plan.
id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
plans List<Property Map>: A SQL execution plan as a list of steps.
sqlObjectId String
sqlTuningAdvisorTaskId String

Supporting Types

GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan

AccessPredicates string: The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
Attribute string: The attribute of the SQL execution plan.
Bytes string: The number of bytes returned by the current operation.
Cardinality string: The number of rows returned by the current operation (estimated by the CBO).
Cost double: The cost of the current operation estimated by the cost-based optimizer (CBO).
CpuCost double: The CPU cost of the current operation.
FilterPredicates string: The predicates used to filter rows before producing them.
IoCost double: The I/O cost of the current operation.
NumberOfSearchColumn int: Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
Object string: The name of the object.
ObjectNode string: The name of the database link used to reference the object.
ObjectOwner string: The owner of the object.
ObjectPosition int: The numbered position of the object name in the original SQL statement.
ObjectType string: The descriptive modifier that further describes the type of object.
Operation string: The name of the operation performed at this step.
OptimizerMode string: The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).
Options string: The options used for the operation performed at this step.
Other string: Information about parallel execution servers and parallel queries
OtherTag string: Describes the function of the SQL text in the OTHER column.
ParentStepId int: The ID of the next step that operates on the results of this step. This is not the OCID.
PartitionId int: The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.
PartitionStart string: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
PartitionStop string: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
PlanHashValue string: The numerical representation of the SQL execution plan.
Position int: The order of processing for steps with the same parent ID.
Remarks string: The place for comments that can be added to the steps of the execution plan.
StepId int: The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
TempSpace string: The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
Time string: The elapsed time (in seconds) of the operation as estimated by the CBO.

AccessPredicates string: The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
Attribute string: The attribute of the SQL execution plan.
Bytes string: The number of bytes returned by the current operation.
Cardinality string: The number of rows returned by the current operation (estimated by the CBO).
Cost float64: The cost of the current operation estimated by the cost-based optimizer (CBO).
CpuCost float64: The CPU cost of the current operation.
FilterPredicates string: The predicates used to filter rows before producing them.
IoCost float64: The I/O cost of the current operation.
NumberOfSearchColumn int: Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
Object string: The name of the object.
ObjectNode string: The name of the database link used to reference the object.
ObjectOwner string: The owner of the object.
ObjectPosition int: The numbered position of the object name in the original SQL statement.
ObjectType string: The descriptive modifier that further describes the type of object.
Operation string: The name of the operation performed at this step.
OptimizerMode string: The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).
Options string: The options used for the operation performed at this step.
Other string: Information about parallel execution servers and parallel queries
OtherTag string: Describes the function of the SQL text in the OTHER column.
ParentStepId int: The ID of the next step that operates on the results of this step. This is not the OCID.
PartitionId int: The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.
PartitionStart string: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
PartitionStop string: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
PlanHashValue string: The numerical representation of the SQL execution plan.
Position int: The order of processing for steps with the same parent ID.
Remarks string: The place for comments that can be added to the steps of the execution plan.
StepId int: The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
TempSpace string: The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
Time string: The elapsed time (in seconds) of the operation as estimated by the CBO.

accessPredicates String: The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
attribute String: The attribute of the SQL execution plan.
bytes String: The number of bytes returned by the current operation.
cardinality String: The number of rows returned by the current operation (estimated by the CBO).
cost Double: The cost of the current operation estimated by the cost-based optimizer (CBO).
cpuCost Double: The CPU cost of the current operation.
filterPredicates String: The predicates used to filter rows before producing them.
ioCost Double: The I/O cost of the current operation.
numberOfSearchColumn Integer: Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
object String: The name of the object.
objectNode String: The name of the database link used to reference the object.
objectOwner String: The owner of the object.
objectPosition Integer: The numbered position of the object name in the original SQL statement.
objectType String: The descriptive modifier that further describes the type of object.
operation String: The name of the operation performed at this step.
optimizerMode String: The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).
options String: The options used for the operation performed at this step.
other String: Information about parallel execution servers and parallel queries
otherTag String: Describes the function of the SQL text in the OTHER column.
parentStepId Integer: The ID of the next step that operates on the results of this step. This is not the OCID.
partitionId Integer: The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.
partitionStart String: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
partitionStop String: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
planHashValue String: The numerical representation of the SQL execution plan.
position Integer: The order of processing for steps with the same parent ID.
remarks String: The place for comments that can be added to the steps of the execution plan.
stepId Integer: The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
tempSpace String: The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
time String: The elapsed time (in seconds) of the operation as estimated by the CBO.

accessPredicates string: The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
attribute string: The attribute of the SQL execution plan.
bytes string: The number of bytes returned by the current operation.
cardinality string: The number of rows returned by the current operation (estimated by the CBO).
cost number: The cost of the current operation estimated by the cost-based optimizer (CBO).
cpuCost number: The CPU cost of the current operation.
filterPredicates string: The predicates used to filter rows before producing them.
ioCost number: The I/O cost of the current operation.
numberOfSearchColumn number: Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
object string: The name of the object.
objectNode string: The name of the database link used to reference the object.
objectOwner string: The owner of the object.
objectPosition number: The numbered position of the object name in the original SQL statement.
objectType string: The descriptive modifier that further describes the type of object.
operation string: The name of the operation performed at this step.
optimizerMode string: The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).
options string: The options used for the operation performed at this step.
other string: Information about parallel execution servers and parallel queries
otherTag string: Describes the function of the SQL text in the OTHER column.
parentStepId number: The ID of the next step that operates on the results of this step. This is not the OCID.
partitionId number: The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.
partitionStart string: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
partitionStop string: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
planHashValue string: The numerical representation of the SQL execution plan.
position number: The order of processing for steps with the same parent ID.
remarks string: The place for comments that can be added to the steps of the execution plan.
stepId number: The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
tempSpace string: The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
time string: The elapsed time (in seconds) of the operation as estimated by the CBO.

access_predicates str: The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
attribute str: The attribute of the SQL execution plan.
bytes str: The number of bytes returned by the current operation.
cardinality str: The number of rows returned by the current operation (estimated by the CBO).
cost float: The cost of the current operation estimated by the cost-based optimizer (CBO).
cpu_cost float: The CPU cost of the current operation.
filter_predicates str: The predicates used to filter rows before producing them.
io_cost float: The I/O cost of the current operation.
number_of_search_column int: Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
object str: The name of the object.
object_node str: The name of the database link used to reference the object.
object_owner str: The owner of the object.
object_position int: The numbered position of the object name in the original SQL statement.
object_type str: The descriptive modifier that further describes the type of object.
operation str: The name of the operation performed at this step.
optimizer_mode str: The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).
options str: The options used for the operation performed at this step.
other str: Information about parallel execution servers and parallel queries
other_tag str: Describes the function of the SQL text in the OTHER column.
parent_step_id int: The ID of the next step that operates on the results of this step. This is not the OCID.
partition_id int: The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.
partition_start str: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
partition_stop str: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
plan_hash_value str: The numerical representation of the SQL execution plan.
position int: The order of processing for steps with the same parent ID.
remarks str: The place for comments that can be added to the steps of the execution plan.
step_id int: The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
temp_space str: The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
time str: The elapsed time (in seconds) of the operation as estimated by the CBO.

accessPredicates String: The predicates used to locate rows in an access structure. For example, start or stop predicates for an index range scan.
attribute String: The attribute of the SQL execution plan.
bytes String: The number of bytes returned by the current operation.
cardinality String: The number of rows returned by the current operation (estimated by the CBO).
cost Number: The cost of the current operation estimated by the cost-based optimizer (CBO).
cpuCost Number: The CPU cost of the current operation.
filterPredicates String: The predicates used to filter rows before producing them.
ioCost Number: The I/O cost of the current operation.
numberOfSearchColumn Number: Number of index columns with start and stop keys (that is, the number of columns with matching predicates).
object String: The name of the object.
objectNode String: The name of the database link used to reference the object.
objectOwner String: The owner of the object.
objectPosition Number: The numbered position of the object name in the original SQL statement.
objectType String: The descriptive modifier that further describes the type of object.
operation String: The name of the operation performed at this step.
optimizerMode String: The current mode of the optimizer, such as all_rows, first_rows_n (where n = 1, 10, 100, 1000, and so on).
options String: The options used for the operation performed at this step.
other String: Information about parallel execution servers and parallel queries
otherTag String: Describes the function of the SQL text in the OTHER column.
parentStepId Number: The ID of the next step that operates on the results of this step. This is not the OCID.
partitionId Number: The ID of the step in the execution plan that has computed the pair of values of partitionStart and partitionStop.
partitionStart String: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
partitionStop String: A step may get data from a range of partitions of a partitioned object, such as table or index, based on predicates and sorting order. The partionStart is the starting partition of the range. The partitionStop is the ending partition of the range.
planHashValue String: The numerical representation of the SQL execution plan.
position Number: The order of processing for steps with the same parent ID.
remarks String: The place for comments that can be added to the steps of the execution plan.
stepId Number: The identification number of a step in the SQL execution plan. This is unique within the SQL execution plan. This is not the OCID.
tempSpace String: The temporary space usage (in bytes) of the operation (sort or hash-join) as estimated by the CBO.
time String: The elapsed time (in seconds) of the operation as estimated by the CBO.

Package Details

Repository: https://github.com/pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.