Oracle Cloud Infrastructure v2.30.0, Apr 14 25

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutions

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

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.

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

const testManagedDatabaseOptimizerStatisticsAdvisorExecutions = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutions({
    managedDatabaseId: testManagedDatabase.id,
    endTimeLessThanOrEqualTo: managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo,
    startTimeGreaterThanOrEqualTo: managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo,
});

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=test_managed_database["id"],
    end_time_less_than_or_equal_to=managed_database_optimizer_statistics_advisor_execution_end_time_less_than_or_equal_to,
    start_time_greater_than_or_equal_to=managed_database_optimizer_statistics_advisor_execution_start_time_greater_than_or_equal_to)

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.GetManagedDatabaseOptimizerStatisticsAdvisorExecutions(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs{
			ManagedDatabaseId:             testManagedDatabase.Id,
			EndTimeLessThanOrEqualTo:      pulumi.StringRef(managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo),
			StartTimeGreaterThanOrEqualTo: pulumi.StringRef(managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo),
		}, 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 testManagedDatabaseOptimizerStatisticsAdvisorExecutions = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutions.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        EndTimeLessThanOrEqualTo = managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo,
        StartTimeGreaterThanOrEqualTo = managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo,
    });

});

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(testManagedDatabase.id())
            .endTimeLessThanOrEqualTo(managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo)
            .startTimeGreaterThanOrEqualTo(managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo)
            .build());

    }
}

variables:
  testManagedDatabaseOptimizerStatisticsAdvisorExecutions:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsAdvisorExecutions
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        endTimeLessThanOrEqualTo: ${managedDatabaseOptimizerStatisticsAdvisorExecutionEndTimeLessThanOrEqualTo}
        startTimeGreaterThanOrEqualTo: ${managedDatabaseOptimizerStatisticsAdvisorExecutionStartTimeGreaterThanOrEqualTo}

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.

TypeScript
Python
Go
C#
Java
YAML

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)
public static Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsResult> getManagedDatabaseOptimizerStatisticsAdvisorExecutions(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsArgs args, InvokeOptions options)

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 Sequence[databasemanagement.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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection>: The list of optimizer_statistics_advisor_executions_collection.
EndTimeLessThanOrEqualTo string
Filters List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter>
StartTimeGreaterThanOrEqualTo string

Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
OptimizerStatisticsAdvisorExecutionsCollections []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection: The list of optimizer_statistics_advisor_executions_collection.
EndTimeLessThanOrEqualTo string
Filters []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter
StartTimeGreaterThanOrEqualTo string

id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
optimizerStatisticsAdvisorExecutionsCollections List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection>: The list of optimizer_statistics_advisor_executions_collection.
endTimeLessThanOrEqualTo String
filters List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter>
startTimeGreaterThanOrEqualTo String

id string: The provider-assigned unique ID for this managed resource.
managedDatabaseId string
optimizerStatisticsAdvisorExecutionsCollections GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection[]: The list of optimizer_statistics_advisor_executions_collection.
endTimeLessThanOrEqualTo string
filters GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter[]
startTimeGreaterThanOrEqualTo string

id str: The provider-assigned unique ID for this managed resource.
managed_database_id str
optimizer_statistics_advisor_executions_collections Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection]: The list of optimizer_statistics_advisor_executions_collection.
end_time_less_than_or_equal_to str
filters Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter]
start_time_greater_than_or_equal_to str

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

Items List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem>

Items []GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem

items List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem>

items GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem[]

items Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem]

items List<Property Map>

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 Sequence[databasemanagement.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 Sequence[databasemanagement.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 Sequence[databasemanagement.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 List<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<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 str: The description of the rule.
findings Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFinding]: 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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFinding

Details List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetail>: The details of the schema or operation.
Message string: The message of the rationale.
Recommendations List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendation>: The list of recommendations.

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

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

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

details Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetail]: The details of the schema or operation.
message str: The message of the rationale.
recommendations Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendation]: 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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetail

Operations List<string>: The list of operation details.
Schemas List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema>: The names of the impacted database schemas and their objects.

Operations []string: 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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema>: The names of the impacted database schemas and their objects.

operations string[]: The list of operation details.
schemas GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema[]: The names of the impacted database schemas and their objects.

operations Sequence[str]: The list of operation details.
schemas Sequence[databasemanagement.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<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExample>: An example of the recommendation.
Message string: The message of the rationale.
Rationales List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationRationale>: The rationale of the recommendation.

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

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

examples GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExample[]: An example of the recommendation.
message string: The message of the rationale.
rationales GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationRationale[]: The rationale of the recommendation.

examples Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExample]: An example of the recommendation.
message str: The message of the rationale.
rationales Sequence[databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationRationale]: 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.

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExample

Lines List<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExampleLine>: The list of examples for the recommendation.

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

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

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

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

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

Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutions

On this page

On this page

Example Usage

Using getManagedDatabaseOptimizerStatisticsAdvisorExecutions

getManagedDatabaseOptimizerStatisticsAdvisorExecutions Result

Supporting Types

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsFilter

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollection

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItem

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemDatabase

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReport

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRule

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFinding

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetail

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingDetailSchema

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendation

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExample

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationExampleLine

GetManagedDatabaseOptimizerStatisticsAdvisorExecutionsOptimizerStatisticsAdvisorExecutionsCollectionItemReportRuleFindingRecommendationRationale

Package Details

On this page

On this page