Oracle Cloud Infrastructure

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

getManagedDatabaseOptimizerStatisticsAdvisorExecutions

This data source provides the list of Managed Database Optimizer Statistics Advisor Executions in Oracle Cloud Infrastructure Database Management service.

Lists the details of the Optimizer Statistics Advisor task executions, such as their duration, and the number of findings, if any. Optionally, you can specify a date-time range (of seven days) to obtain the list of executions that fall within the specified time range. If the date-time range is not specified, then the executions in the last seven days are listed.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseOptimizerStatisticsAdvisorExecutions = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutions.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        EndTimeLessThanOrEqualTo = @var.Managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to,
        StartTimeGreaterThanOrEqualTo = @var.Managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to,
    });

});
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.GetManagedDatabaseOptimizerStatisticsAdvisorExecutions(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs{
			ManagedDatabaseId:             oci_database_management_managed_database.Test_managed_database.Id,
			EndTimeLessThanOrEqualTo:      pulumi.StringRef(_var.Managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to),
			StartTimeGreaterThanOrEqualTo: pulumi.StringRef(_var.Managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to),
		}, 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.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs;
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 testManagedDatabaseOptimizerStatisticsAdvisorExecutions = DatabaseManagementFunctions.getManagedDatabaseOptimizerStatisticsAdvisorExecutions(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs.builder()
            .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
            .endTimeLessThanOrEqualTo(var_.managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to())
            .startTimeGreaterThanOrEqualTo(var_.managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_managed_database_optimizer_statistics_advisor_executions = oci.DatabaseManagement.get_managed_database_optimizer_statistics_advisor_executions(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
    end_time_less_than_or_equal_to=var["managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to"],
    start_time_greater_than_or_equal_to=var["managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseOptimizerStatisticsAdvisorExecutions = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutions({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    endTimeLessThanOrEqualTo: _var.managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to,
    startTimeGreaterThanOrEqualTo: _var.managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to,
});
variables:
  testManagedDatabaseOptimizerStatisticsAdvisorExecutions:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsAdvisorExecutions
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        endTimeLessThanOrEqualTo: ${var.managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to}
        startTimeGreaterThanOrEqualTo: ${var.managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to}

Using getManagedDatabaseOptimizerStatisticsAdvisorExecutions

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 getManagedDatabaseOptimizerStatisticsAdvisorExecutions(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult>
function getManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutput(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult>
def get_managed_database_optimizer_statistics_advisor_executions(end_time_less_than_or_equal_to: Optional[str] = None,
                                                                 filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter]] = None,
                                                                 managed_database_id: Optional[str] = None,
                                                                 start_time_greater_than_or_equal_to: Optional[str] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult
def get_managed_database_optimizer_statistics_advisor_executions_output(end_time_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                 filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilterArgs]]]] = None,
                                                                 managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                 start_time_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult]
func GetManagedDatabaseOptimizerStatisticsAdvisorExecutions(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs, opts ...InvokeOption) (*GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult, error)
func GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutput(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOutputArgs, opts ...InvokeOption) GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResultOutput

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

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

The following arguments are supported:

ManagedDatabaseId string

The OCID of the Managed Database.

EndTimeLessThanOrEqualTo string

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

Filters List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter>
StartTimeGreaterThanOrEqualTo string

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

ManagedDatabaseId string

The OCID of the Managed Database.

EndTimeLessThanOrEqualTo string

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

Filters []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter
StartTimeGreaterThanOrEqualTo string

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

managedDatabaseId String

The OCID of the Managed Database.

endTimeLessThanOrEqualTo String

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

filters List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter>
startTimeGreaterThanOrEqualTo String

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

managedDatabaseId string

The OCID of the Managed Database.

endTimeLessThanOrEqualTo string

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

filters GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter[]
startTimeGreaterThanOrEqualTo string

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

managed_database_id str

The OCID of the Managed Database.

end_time_less_than_or_equal_to str

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

filters GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter]
start_time_greater_than_or_equal_to str

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

managedDatabaseId String

The OCID of the Managed Database.

endTimeLessThanOrEqualTo String

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

filters List<Property Map>
startTimeGreaterThanOrEqualTo String

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

getManagedDatabaseOptimizerStatisticsAdvisorExecutions Result

The following output properties are available:

id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
optimizerStatisticsAdvisorExecutionsCollections List<Property Map>

The list of optimizer_statistics_advisor_executions_collection.

endTimeLessThanOrEqualTo String
filters List<Property Map>
startTimeGreaterThanOrEqualTo String

Supporting Types

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter

Name string

The name of the rule.

Values List<string>
Regex bool
Name string

The name of the rule.

Values []string
Regex bool
name String

The name of the rule.

values List<String>
regex Boolean
name string

The name of the rule.

values string[]
regex boolean
name str

The name of the rule.

values Sequence[str]
regex bool
name String

The name of the rule.

values List<String>
regex Boolean

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem

Databases List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase>

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.

Reports List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport>

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 []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase

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.

Reports []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport

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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase>

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.

reports List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport>

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 GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase[]

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.

reports GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport[]

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 GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase]

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.

reports GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport]

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.

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'".

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport

Rules List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule>

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 []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule

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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule>

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 GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule[]

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 GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule]

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule

Description string

The description of the rule.

Findings []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFinding

The list of findings for the rule.

Name string

The name of the rule.

description string

The description of the rule.

findings GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFinding[]

The list of findings for the rule.

name string

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFinding

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetail

Operations List<string>

The list of operation details.

Schemas List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema>

The names of the impacted database schemas and their objects.

operations List<String>

The list of operation details.

schemas List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema>

The names of the impacted database schemas and their objects.

operations Sequence[str]

The list of operation details.

schemas GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema]

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendation

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExample

lines List<Property Map>

The list of examples for the recommendation.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExampleLine

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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationRationale

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.