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.