Oracle Cloud Infrastructure v2.31.0, Apr 17 25

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecution

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseOptimizerStatisticsAdvisorExecution = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecution({
    executionName: managedDatabaseOptimizerStatisticsAdvisorExecutionExecutionName,
    managedDatabaseId: testManagedDatabase.id,
    taskName: managedDatabaseOptimizerStatisticsAdvisorExecutionTaskName,
});

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=managed_database_optimizer_statistics_advisor_execution_execution_name,
    managed_database_id=test_managed_database["id"],
    task_name=managed_database_optimizer_statistics_advisor_execution_task_name)

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.GetManagedDatabaseOptimizerStatisticsAdvisorExecution(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs{
			ExecutionName:     managedDatabaseOptimizerStatisticsAdvisorExecutionExecutionName,
			ManagedDatabaseId: testManagedDatabase.Id,
			TaskName:          managedDatabaseOptimizerStatisticsAdvisorExecutionTaskName,
		}, 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 testManagedDatabaseOptimizerStatisticsAdvisorExecution = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecution.Invoke(new()
    {
        ExecutionName = managedDatabaseOptimizerStatisticsAdvisorExecutionExecutionName,
        ManagedDatabaseId = testManagedDatabase.Id,
        TaskName = managedDatabaseOptimizerStatisticsAdvisorExecutionTaskName,
    });

});

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(managedDatabaseOptimizerStatisticsAdvisorExecutionExecutionName)
            .managedDatabaseId(testManagedDatabase.id())
            .taskName(managedDatabaseOptimizerStatisticsAdvisorExecutionTaskName)
            .build());

    }
}

variables:
  testManagedDatabaseOptimizerStatisticsAdvisorExecution:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsAdvisorExecution
      arguments:
        executionName: ${managedDatabaseOptimizerStatisticsAdvisorExecutionExecutionName}
        managedDatabaseId: ${testManagedDatabase.id}
        taskName: ${managedDatabaseOptimizerStatisticsAdvisorExecutionTaskName}

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)
public static Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionResult> getManagedDatabaseOptimizerStatisticsAdvisorExecution(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionArgs args, InvokeOptions options)

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 Sequence[databasemanagement.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 Sequence[databasemanagement.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 Sequence[databasemanagement.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 Sequence[databasemanagement.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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail>: The details of the schema or operation.
Message string: The message of the rationale.
Recommendations List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation>: The list of recommendations.

Details []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail: The details of the schema or operation.
Message string: The message of the rationale.
Recommendations []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation: The list of recommendations.

details List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail>: The details of the schema or operation.
message String: The message of the rationale.
recommendations List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation>: The list of recommendations.

details GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail[]: The details of the schema or operation.
message string: The message of the rationale.
recommendations GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation[]: The list of recommendations.

details Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail]: The details of the schema or operation.
message str: The message of the rationale.
recommendations Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation]: The list of recommendations.

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 Sequence[databasemanagement.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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample>: An example of the recommendation.
Message string: The message of the rationale.
Rationales List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale>: The rationale of the recommendation.

Examples []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample: An example of the recommendation.
Message string: The message of the rationale.
Rationales []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale: The rationale of the recommendation.

examples List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample>: An example of the recommendation.
message String: The message of the rationale.
rationales List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale>: The rationale of the recommendation.

examples GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample[]: An example of the recommendation.
message string: The message of the rationale.
rationales GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale[]: The rationale of the recommendation.

examples Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample]: An example of the recommendation.
message str: The message of the rationale.
rationales Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale]: The rationale of the recommendation.

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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine>: The list of examples for the recommendation.

Lines []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine: The list of examples for the recommendation.

lines List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine>: The list of examples for the recommendation.

lines GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine[]: The list of examples for the recommendation.

lines Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine]: The list of examples for the recommendation.

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: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecution

On this page

On this page

Example Usage

Using getManagedDatabaseOptimizerStatisticsAdvisorExecution

getManagedDatabaseOptimizerStatisticsAdvisorExecution Result

Supporting Types

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionDatabase

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReport

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRule

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFinding

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetail

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingDetailSchema

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendation

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExample

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationExampleLine

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionReportRuleFindingRecommendationRationale

Package Details

On this page

On this page