Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

    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

    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,
});

    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=managed_database_sql_tuning_advisor_tasks_sql_execution_plan_attribute,
    managed_database_id=test_managed_database["id"],
    sql_object_id=test_object["id"],
    sql_tuning_advisor_task_id=test_sql_tuning_advisor_task["id"],
    opc_named_credential_id=managed_database_sql_tuning_advisor_tasks_sql_execution_plan_opc_named_credential_id)

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/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:              managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanAttribute,
			ManagedDatabaseId:      testManagedDatabase.Id,
			SqlObjectId:            testObject.Id,
			SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
			OpcNamedCredentialId:   pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOpcNamedCredentialId),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan.Invoke(new()
    {
        Attribute = managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanAttribute,
        ManagedDatabaseId = testManagedDatabase.Id,
        SqlObjectId = testObject.Id,
        SqlTuningAdvisorTaskId = testSqlTuningAdvisorTask.Id,
        OpcNamedCredentialId = managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOpcNamedCredentialId,
    });

});

    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.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs;
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 testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs.builder()
            .attribute(managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanAttribute)
            .managedDatabaseId(testManagedDatabase.id())
            .sqlObjectId(testObject.id())
            .sqlTuningAdvisorTaskId(testSqlTuningAdvisorTask.id())
            .opcNamedCredentialId(managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOpcNamedCredentialId)
            .build());

    }
}

    variables:
  testManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan
      arguments:
        attribute: ${managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanAttribute}
        managedDatabaseId: ${testManagedDatabase.id}
        sqlObjectId: ${testObject.id}
        sqlTuningAdvisorTaskId: ${testSqlTuningAdvisorTask.id}
        opcNamedCredentialId: ${managedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanOpcNamedCredentialId}

    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,
                                                                     opc_named_credential_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,
                                                                     opc_named_credential_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)
public static Output<GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanResult> getManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlan(GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanArgs args, InvokeOptions options)

    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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.
    opcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    opc_named_credential_id str
    The OCID of the Named Credential.
    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.
    opcNamedCredentialId String
    The OCID of the Named Credential.

    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
    OpcNamedCredentialId 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
    OpcNamedCredentialId 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
    opcNamedCredentialId 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
    opcNamedCredentialId 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 Sequence[databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSqlExecutionPlanPlan]
    A SQL execution plan as a list of steps.
    sql_object_id str
    sql_tuning_advisor_task_id str
    opc_named_credential_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
    opcNamedCredentialId 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
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
    pulumi/pulumi-oci