Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getManagedDatabaseOptimizerStatisticsAdvisorExecution

This data source provides details about a specific Managed Database Optimizer Statistics Advisor Execution resource in Oracle Cloud Infrastructure Database Management service.

Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes details of the Managed Database, findings, recommendations, rationale, and examples.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseOptimizerStatisticsAdvisorExecution = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecution.Invoke(new()
    {
        ExecutionName = @var.Managed_database_optimizer_statistics_advisor_execution_execution_name,
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        TaskName = @var.Managed_database_optimizer_statistics_advisor_execution_task_name,
    });

});
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.GetManagedDatabaseOptimizerStatisticsAdvisorExecution(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs{
			ExecutionName:     _var.Managed_database_optimizer_statistics_advisor_execution_execution_name,
			ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.Id,
			TaskName:          _var.Managed_database_optimizer_statistics_advisor_execution_task_name,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs;
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 testManagedDatabaseOptimizerStatisticsAdvisorExecution = DatabaseManagementFunctions.getManagedDatabaseOptimizerStatisticsAdvisorExecution(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs.builder()
            .executionName(var_.managed_database_optimizer_statistics_advisor_execution_execution_name())
            .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
            .taskName(var_.managed_database_optimizer_statistics_advisor_execution_task_name())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_managed_database_optimizer_statistics_advisor_execution = oci.DatabaseManagement.get_managed_database_optimizer_statistics_advisor_execution(execution_name=var["managed_database_optimizer_statistics_advisor_execution_execution_name"],
    managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
    task_name=var["managed_database_optimizer_statistics_advisor_execution_task_name"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseOptimizerStatisticsAdvisorExecution = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecution({
    executionName: _var.managed_database_optimizer_statistics_advisor_execution_execution_name,
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    taskName: _var.managed_database_optimizer_statistics_advisor_execution_task_name,
});
variables:
  testManagedDatabaseOptimizerStatisticsAdvisorExecution:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsAdvisorExecution
      Arguments:
        executionName: ${var.managed_database_optimizer_statistics_advisor_execution_execution_name}
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        taskName: ${var.managed_database_optimizer_statistics_advisor_execution_task_name}

Using getManagedDatabaseOptimizerStatisticsAdvisorExecution

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 getManagedDatabaseOptimizerStatisticsAdvisorExecution(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult>
function getManagedDatabaseOptimizerStatisticsAdvisorExecutionOutput(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult>
def get_managed_database_optimizer_statistics_advisor_execution(execution_name: Optional[str] = None,
                                                                managed_database_id: Optional[str] = None,
                                                                task_name: Optional[str] = None,
                                                                opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult
def get_managed_database_optimizer_statistics_advisor_execution_output(execution_name: Optional[pulumi.Input[str]] = None,
                                                                managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                task_name: Optional[pulumi.Input[str]] = None,
                                                                opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult]
func GetManagedDatabaseOptimizerStatisticsAdvisorExecution(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs, opts ...InvokeOption) (*GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult, error)
func GetManagedDatabaseOptimizerStatisticsAdvisorExecutionOutput(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsAdvisorExecutionOutputArgs, opts ...InvokeOption) GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResultOutput

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

public static class GetManagedDatabaseOptimizerStatisticsAdvisorExecution 
{
    public static Task<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult> InvokeAsync(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult> Invoke(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult> getManagedDatabaseOptimizerStatisticsAdvisorExecution(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseOptimizerStatisticsAdvisorExecution:getManagedDatabaseOptimizerStatisticsAdvisorExecution
  Arguments:
    # Arguments dictionary

The following arguments are supported:

ExecutionName string

The name of the Optimizer Statistics Advisor execution.

ManagedDatabaseId string

The OCID of the Managed Database.

TaskName string

The name of the optimizer statistics collection execution task.

ExecutionName string

The name of the Optimizer Statistics Advisor execution.

ManagedDatabaseId string

The OCID of the Managed Database.

TaskName string

The name of the optimizer statistics collection execution task.

executionName String

The name of the Optimizer Statistics Advisor execution.

managedDatabaseId String

The OCID of the Managed Database.

taskName String

The name of the optimizer statistics collection execution task.

executionName string

The name of the Optimizer Statistics Advisor execution.

managedDatabaseId string

The OCID of the Managed Database.

taskName string

The name of the optimizer statistics collection execution task.

execution_name str

The name of the Optimizer Statistics Advisor execution.

managed_database_id str

The OCID of the Managed Database.

task_name str

The name of the optimizer statistics collection execution task.

executionName String

The name of the Optimizer Statistics Advisor execution.

managedDatabaseId String

The OCID of the Managed Database.

taskName String

The name of the optimizer statistics collection execution task.

getManagedDatabaseOptimizerStatisticsAdvisorExecution Result

The following output properties are available:

Databases List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase>

The summary of the Managed Database resource.

ErrorMessage string

The errors in the Optimizer Statistics Advisor execution, if any.

ExecutionName string

The name of the Optimizer Statistics Advisor execution.

Findings int

The list of findings for the rule.

Id string

The provider-assigned unique ID for this managed resource.

ManagedDatabaseId string
Reports List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport>

A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.

Status string

The status of the Optimizer Statistics Advisor execution.

StatusMessage string

The Optimizer Statistics Advisor execution status message, if any.

TaskName string

The name of the Optimizer Statistics Advisor task.

TimeEnd string

The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

TimeStart string

The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

Databases []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase

The summary of the Managed Database resource.

ErrorMessage string

The errors in the Optimizer Statistics Advisor execution, if any.

ExecutionName string

The name of the Optimizer Statistics Advisor execution.

Findings int

The list of findings for the rule.

Id string

The provider-assigned unique ID for this managed resource.

ManagedDatabaseId string
Reports []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport

A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.

Status string

The status of the Optimizer Statistics Advisor execution.

StatusMessage string

The Optimizer Statistics Advisor execution status message, if any.

TaskName string

The name of the Optimizer Statistics Advisor task.

TimeEnd string

The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

TimeStart string

The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

databases List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase>

The summary of the Managed Database resource.

errorMessage String

The errors in the Optimizer Statistics Advisor execution, if any.

executionName String

The name of the Optimizer Statistics Advisor execution.

findings Integer

The list of findings for the rule.

id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
reports List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport>

A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.

status String

The status of the Optimizer Statistics Advisor execution.

statusMessage String

The Optimizer Statistics Advisor execution status message, if any.

taskName String

The name of the Optimizer Statistics Advisor task.

timeEnd String

The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

timeStart String

The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

databases GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase[]

The summary of the Managed Database resource.

errorMessage string

The errors in the Optimizer Statistics Advisor execution, if any.

executionName string

The name of the Optimizer Statistics Advisor execution.

findings number

The list of findings for the rule.

id string

The provider-assigned unique ID for this managed resource.

managedDatabaseId string
reports GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport[]

A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.

status string

The status of the Optimizer Statistics Advisor execution.

statusMessage string

The Optimizer Statistics Advisor execution status message, if any.

taskName string

The name of the Optimizer Statistics Advisor task.

timeEnd string

The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

timeStart string

The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

databases GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase]

The summary of the Managed Database resource.

error_message str

The errors in the Optimizer Statistics Advisor execution, if any.

execution_name str

The name of the Optimizer Statistics Advisor execution.

findings int

The list of findings for the rule.

id str

The provider-assigned unique ID for this managed resource.

managed_database_id str
reports GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport]

A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.

status str

The status of the Optimizer Statistics Advisor execution.

status_message str

The Optimizer Statistics Advisor execution status message, if any.

task_name str

The name of the Optimizer Statistics Advisor task.

time_end str

The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

time_start str

The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

databases List<Property Map>

The summary of the Managed Database resource.

errorMessage String

The errors in the Optimizer Statistics Advisor execution, if any.

executionName String

The name of the Optimizer Statistics Advisor execution.

findings Number

The list of findings for the rule.

id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
reports List<Property Map>

A report that includes the rules, findings, recommendations, and actions discovered during the execution of the Optimizer Statistics Advisor.

status String

The status of the Optimizer Statistics Advisor execution.

statusMessage String

The Optimizer Statistics Advisor execution status message, if any.

taskName String

The name of the Optimizer Statistics Advisor task.

timeEnd String

The end time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

timeStart String

The start time of the time range to retrieve the Optimizer Statistics Advisor execution of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

Supporting Types

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase

CompartmentId string

The OCID of the compartment in which the Managed Database resides.

DbDeploymentType string

The infrastructure used to deploy the Oracle Database.

DbSubType string

The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.

DbType string

The type of Oracle Database installation.

DbVersion string

The version of the Oracle Database.

Id string

The OCID of the Managed Database.

Name string

The name of the rule.

CompartmentId string

The OCID of the compartment in which the Managed Database resides.

DbDeploymentType string

The infrastructure used to deploy the Oracle Database.

DbSubType string

The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.

DbType string

The type of Oracle Database installation.

DbVersion string

The version of the Oracle Database.

Id string

The OCID of the Managed Database.

Name string

The name of the rule.

compartmentId String

The OCID of the compartment in which the Managed Database resides.

dbDeploymentType String

The infrastructure used to deploy the Oracle Database.

dbSubType String

The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.

dbType String

The type of Oracle Database installation.

dbVersion String

The version of the Oracle Database.

id String

The OCID of the Managed Database.

name String

The name of the rule.

compartmentId string

The OCID of the compartment in which the Managed Database resides.

dbDeploymentType string

The infrastructure used to deploy the Oracle Database.

dbSubType string

The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.

dbType string

The type of Oracle Database installation.

dbVersion string

The version of the Oracle Database.

id string

The OCID of the Managed Database.

name string

The name of the rule.

compartment_id str

The OCID of the compartment in which the Managed Database resides.

db_deployment_type str

The infrastructure used to deploy the Oracle Database.

db_sub_type str

The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.

db_type str

The type of Oracle Database installation.

db_version str

The version of the Oracle Database.

id str

The OCID of the Managed Database.

name str

The name of the rule.

compartmentId String

The OCID of the compartment in which the Managed Database resides.

dbDeploymentType String

The infrastructure used to deploy the Oracle Database.

dbSubType String

The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, Non-container Database, Autonomous Database, or Autonomous Container Database.

dbType String

The type of Oracle Database installation.

dbVersion String

The version of the Oracle Database.

id String

The OCID of the Managed Database.

name String

The name of the rule.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport

Rules List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule>

The list of rules that were not adhered to by the Optimizer Statistics Collection.

Summary string

A summary of the Optimizer Statistics Advisor execution.

Rules []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule

The list of rules that were not adhered to by the Optimizer Statistics Collection.

Summary string

A summary of the Optimizer Statistics Advisor execution.

rules List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule>

The list of rules that were not adhered to by the Optimizer Statistics Collection.

summary String

A summary of the Optimizer Statistics Advisor execution.

rules GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule[]

The list of rules that were not adhered to by the Optimizer Statistics Collection.

summary string

A summary of the Optimizer Statistics Advisor execution.

rules GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule]

The list of rules that were not adhered to by the Optimizer Statistics Collection.

summary str

A summary of the Optimizer Statistics Advisor execution.

rules List<Property Map>

The list of rules that were not adhered to by the Optimizer Statistics Collection.

summary String

A summary of the Optimizer Statistics Advisor execution.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule

Description string

The description of the rule.

Findings List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding>

The list of findings for the rule.

Name string

The name of the rule.

Description string

The description of the rule.

Findings []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding

The list of findings for the rule.

Name string

The name of the rule.

description String

The description of the rule.

findings List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding>

The list of findings for the rule.

name String

The name of the rule.

description string

The description of the rule.

findings GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding[]

The list of findings for the rule.

name string

The name of the rule.

description str

The description of the rule.

findings GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding]

The list of findings for the rule.

name str

The name of the rule.

description String

The description of the rule.

findings List<Property Map>

The list of findings for the rule.

name String

The name of the rule.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding

details List<Property Map>

The details of the schema or operation.

message String

The message of the rationale.

recommendations List<Property Map>

The list of recommendations.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail

Operations List<string>

The list of operation details.

Schemas List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema>

The names of the impacted database schemas and their objects.

Operations []string

The list of operation details.

Schemas []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema

The names of the impacted database schemas and their objects.

operations List<String>

The list of operation details.

schemas List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema>

The names of the impacted database schemas and their objects.

operations string[]

The list of operation details.

schemas GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema[]

The names of the impacted database schemas and their objects.

operations Sequence[str]

The list of operation details.

schemas GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema]

The names of the impacted database schemas and their objects.

operations List<String>

The list of operation details.

schemas List<Property Map>

The names of the impacted database schemas and their objects.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema

Name string

The name of the rule.

Objects List<string>

The names of schema objects.

Name string

The name of the rule.

Objects []string

The names of schema objects.

name String

The name of the rule.

objects List<String>

The names of schema objects.

name string

The name of the rule.

objects string[]

The names of schema objects.

name str

The name of the rule.

objects Sequence[str]

The names of schema objects.

name String

The name of the rule.

objects List<String>

The names of schema objects.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation

examples List<Property Map>

An example of the recommendation.

message String

The message of the rationale.

rationales List<Property Map>

The rationale of the recommendation.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample

lines List<Property Map>

The list of examples for the recommendation.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine

Comment string

The comments about the operation.

Operation string

The details of the example operation.

Comment string

The comments about the operation.

Operation string

The details of the example operation.

comment String

The comments about the operation.

operation String

The details of the example operation.

comment string

The comments about the operation.

operation string

The details of the example operation.

comment str

The comments about the operation.

operation str

The details of the example operation.

comment String

The comments about the operation.

operation String

The details of the example operation.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale

Message string

The message of the rationale.

Message string

The message of the rationale.

message String

The message of the rationale.

message string

The message of the rationale.

message str

The message of the rationale.

message String

The message of the rationale.

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.