Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseOptimizerStatisticsCollectionOperations
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperations

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

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

    Lists the optimizer statistics (Auto and Manual) task operation summary for the specified Managed Database. The summary includes the details of each operation and the number of tasks grouped by status: Completed, In Progress, Failed, and so on. Optionally, you can specify a date-time range (of seven days) to obtain the list of operations that fall within the specified time range. If the date-time range is not specified, then the operations in the last seven days are listed. This API also enables the pagination of results and the opc-next-page response header indicates whether there is a next page. If you use the same header value in a consecutive request, the next page records are returned. To obtain the required results, you can apply the different types of filters supported by this API.

    Example Usage

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

const testManagedDatabaseOptimizerStatisticsCollectionOperations = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperations({
    managedDatabaseId: testManagedDatabase.id,
    endTimeLessThanOrEqualTo: managedDatabaseOptimizerStatisticsCollectionOperationEndTimeLessThanOrEqualTo,
    filterBy: managedDatabaseOptimizerStatisticsCollectionOperationFilterBy,
    startTimeGreaterThanOrEqualTo: managedDatabaseOptimizerStatisticsCollectionOperationStartTimeGreaterThanOrEqualTo,
    taskType: managedDatabaseOptimizerStatisticsCollectionOperationTaskType,
});

    import pulumi
import pulumi_oci as oci

test_managed_database_optimizer_statistics_collection_operations = oci.DatabaseManagement.get_managed_database_optimizer_statistics_collection_operations(managed_database_id=test_managed_database["id"],
    end_time_less_than_or_equal_to=managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to,
    filter_by=managed_database_optimizer_statistics_collection_operation_filter_by,
    start_time_greater_than_or_equal_to=managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to,
    task_type=managed_database_optimizer_statistics_collection_operation_task_type)

    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.GetManagedDatabaseOptimizerStatisticsCollectionOperations(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs{
			ManagedDatabaseId:             testManagedDatabase.Id,
			EndTimeLessThanOrEqualTo:      pulumi.StringRef(managedDatabaseOptimizerStatisticsCollectionOperationEndTimeLessThanOrEqualTo),
			FilterBy:                      pulumi.StringRef(managedDatabaseOptimizerStatisticsCollectionOperationFilterBy),
			StartTimeGreaterThanOrEqualTo: pulumi.StringRef(managedDatabaseOptimizerStatisticsCollectionOperationStartTimeGreaterThanOrEqualTo),
			TaskType:                      pulumi.StringRef(managedDatabaseOptimizerStatisticsCollectionOperationTaskType),
		}, 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 testManagedDatabaseOptimizerStatisticsCollectionOperations = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionOperations.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        EndTimeLessThanOrEqualTo = managedDatabaseOptimizerStatisticsCollectionOperationEndTimeLessThanOrEqualTo,
        FilterBy = managedDatabaseOptimizerStatisticsCollectionOperationFilterBy,
        StartTimeGreaterThanOrEqualTo = managedDatabaseOptimizerStatisticsCollectionOperationStartTimeGreaterThanOrEqualTo,
        TaskType = managedDatabaseOptimizerStatisticsCollectionOperationTaskType,
    });

});

    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.GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs;
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 testManagedDatabaseOptimizerStatisticsCollectionOperations = DatabaseManagementFunctions.getManagedDatabaseOptimizerStatisticsCollectionOperations(GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .endTimeLessThanOrEqualTo(managedDatabaseOptimizerStatisticsCollectionOperationEndTimeLessThanOrEqualTo)
            .filterBy(managedDatabaseOptimizerStatisticsCollectionOperationFilterBy)
            .startTimeGreaterThanOrEqualTo(managedDatabaseOptimizerStatisticsCollectionOperationStartTimeGreaterThanOrEqualTo)
            .taskType(managedDatabaseOptimizerStatisticsCollectionOperationTaskType)
            .build());

    }
}

    variables:
  testManagedDatabaseOptimizerStatisticsCollectionOperations:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsCollectionOperations
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        endTimeLessThanOrEqualTo: ${managedDatabaseOptimizerStatisticsCollectionOperationEndTimeLessThanOrEqualTo}
        filterBy: ${managedDatabaseOptimizerStatisticsCollectionOperationFilterBy}
        startTimeGreaterThanOrEqualTo: ${managedDatabaseOptimizerStatisticsCollectionOperationStartTimeGreaterThanOrEqualTo}
        taskType: ${managedDatabaseOptimizerStatisticsCollectionOperationTaskType}

    Using getManagedDatabaseOptimizerStatisticsCollectionOperations

    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 getManagedDatabaseOptimizerStatisticsCollectionOperations(args: GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult>
function getManagedDatabaseOptimizerStatisticsCollectionOperationsOutput(args: GetManagedDatabaseOptimizerStatisticsCollectionOperationsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult>
    def get_managed_database_optimizer_statistics_collection_operations(end_time_less_than_or_equal_to: Optional[str] = None,
                                                                    filter_by: Optional[str] = None,
                                                                    filters: Optional[Sequence[GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter]] = None,
                                                                    limit: Optional[int] = None,
                                                                    managed_database_id: Optional[str] = None,
                                                                    start_time_greater_than_or_equal_to: Optional[str] = None,
                                                                    task_type: Optional[str] = None,
                                                                    opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult
def get_managed_database_optimizer_statistics_collection_operations_output(end_time_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                    filter_by: Optional[pulumi.Input[str]] = None,
                                                                    filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilterArgs]]]] = None,
                                                                    limit: Optional[pulumi.Input[int]] = None,
                                                                    managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                    start_time_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                    task_type: Optional[pulumi.Input[str]] = None,
                                                                    opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult]
    func GetManagedDatabaseOptimizerStatisticsCollectionOperations(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs, opts ...InvokeOption) (*GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult, error)
func GetManagedDatabaseOptimizerStatisticsCollectionOperationsOutput(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsCollectionOperationsOutputArgs, opts ...InvokeOption) GetManagedDatabaseOptimizerStatisticsCollectionOperationsResultOutput

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

    public static class GetManagedDatabaseOptimizerStatisticsCollectionOperations 
{
    public static Task<GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult> InvokeAsync(GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult> Invoke(GetManagedDatabaseOptimizerStatisticsCollectionOperationsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult> getManagedDatabaseOptimizerStatisticsCollectionOperations(GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseOptimizerStatisticsCollectionOperationsResult> getManagedDatabaseOptimizerStatisticsCollectionOperations(GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseOptimizerStatisticsCollectionOperations:getManagedDatabaseOptimizerStatisticsCollectionOperations
  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'".
    FilterBy string
    The parameter used to filter the optimizer statistics operations. Any property of the OptimizerStatisticsCollectionOperationSummary can be used to define the filter condition. The allowed conditional operators are AND or OR, and the allowed binary operators are are >, < and =. Any other operator is regarded invalid. Example: jobName= AND status=
    Filters List<GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter>
    Limit int
    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'".
    TaskType string
    The filter types of the optimizer statistics tasks.
    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'".
    FilterBy string
    The parameter used to filter the optimizer statistics operations. Any property of the OptimizerStatisticsCollectionOperationSummary can be used to define the filter condition. The allowed conditional operators are AND or OR, and the allowed binary operators are are >, < and =. Any other operator is regarded invalid. Example: jobName= AND status=
    Filters []GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter
    Limit int
    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'".
    TaskType string
    The filter types of the optimizer statistics tasks.
    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'".
    filterBy String
    The parameter used to filter the optimizer statistics operations. Any property of the OptimizerStatisticsCollectionOperationSummary can be used to define the filter condition. The allowed conditional operators are AND or OR, and the allowed binary operators are are >, < and =. Any other operator is regarded invalid. Example: jobName= AND status=
    filters List<GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter>
    limit Integer
    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'".
    taskType String
    The filter types of the optimizer statistics tasks.
    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'".
    filterBy string
    The parameter used to filter the optimizer statistics operations. Any property of the OptimizerStatisticsCollectionOperationSummary can be used to define the filter condition. The allowed conditional operators are AND or OR, and the allowed binary operators are are >, < and =. Any other operator is regarded invalid. Example: jobName= AND status=
    filters GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter[]
    limit number
    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'".
    taskType string
    The filter types of the optimizer statistics tasks.
    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'".
    filter_by str
    The parameter used to filter the optimizer statistics operations. Any property of the OptimizerStatisticsCollectionOperationSummary can be used to define the filter condition. The allowed conditional operators are AND or OR, and the allowed binary operators are are >, < and =. Any other operator is regarded invalid. Example: jobName= AND status=
    filters Sequence[GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter]
    limit int
    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'".
    task_type str
    The filter types of the optimizer statistics tasks.
    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'".
    filterBy String
    The parameter used to filter the optimizer statistics operations. Any property of the OptimizerStatisticsCollectionOperationSummary can be used to define the filter condition. The allowed conditional operators are AND or OR, and the allowed binary operators are are >, < and =. Any other operator is regarded invalid. Example: jobName= AND status=
    filters List<Property Map>
    limit Number
    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'".
    taskType String
    The filter types of the optimizer statistics tasks.

    getManagedDatabaseOptimizerStatisticsCollectionOperations Result

    The following output properties are available:

    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    optimizerStatisticsCollectionOperationsCollections List<Property Map>
    The list of optimizer_statistics_collection_operations_collection.
    endTimeLessThanOrEqualTo String
    filterBy String
    filters List<Property Map>
    limit Number
    startTimeGreaterThanOrEqualTo String
    taskType String

    Supporting Types

    GetManagedDatabaseOptimizerStatisticsCollectionOperationsFilter

    Name string
    The name of the Managed Database.
    Values List<string>
    Regex bool
    Name string
    The name of the Managed Database.
    Values []string
    Regex bool
    name String
    The name of the Managed Database.
    values List<String>
    regex Boolean
    name string
    The name of the Managed Database.
    values string[]
    regex boolean
    name str
    The name of the Managed Database.
    values Sequence[str]
    regex bool
    name String
    The name of the Managed Database.
    values List<String>
    regex Boolean

    GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollection

    GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItem

    CompletedCount int
    The number of objects for which statistics collection is completed.
    Databases List<GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemDatabase>
    The summary of the Managed Database resource.
    DurationInSeconds double
    The time it takes to complete the operation (in seconds).
    EndTime string
    The end time of the operation.
    FailedCount int
    The number of objects for which statistics collection failed.
    Id int
    The ID of the operation.
    InProgressCount int
    The number of objects for which statistics collection is in progress.
    JobName string
    The name of the job.
    OperationName string
    The name of the operation.
    StartTime string
    The start time of the operation.
    Status string
    The status of the Optimizer Statistics Collection task.
    Target string
    The name of the target object for which statistics are gathered.
    Tasks List<GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemTask>
    An array of Optimizer Statistics Collection task details.
    TimedOutCount int
    The number of objects for which statistics collection timed out.
    TotalObjectsCount int
    The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.
    CompletedCount int
    The number of objects for which statistics collection is completed.
    Databases []GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemDatabase
    The summary of the Managed Database resource.
    DurationInSeconds float64
    The time it takes to complete the operation (in seconds).
    EndTime string
    The end time of the operation.
    FailedCount int
    The number of objects for which statistics collection failed.
    Id int
    The ID of the operation.
    InProgressCount int
    The number of objects for which statistics collection is in progress.
    JobName string
    The name of the job.
    OperationName string
    The name of the operation.
    StartTime string
    The start time of the operation.
    Status string
    The status of the Optimizer Statistics Collection task.
    Target string
    The name of the target object for which statistics are gathered.
    Tasks []GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemTask
    An array of Optimizer Statistics Collection task details.
    TimedOutCount int
    The number of objects for which statistics collection timed out.
    TotalObjectsCount int
    The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.
    completedCount Integer
    The number of objects for which statistics collection is completed.
    databases List<GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemDatabase>
    The summary of the Managed Database resource.
    durationInSeconds Double
    The time it takes to complete the operation (in seconds).
    endTime String
    The end time of the operation.
    failedCount Integer
    The number of objects for which statistics collection failed.
    id Integer
    The ID of the operation.
    inProgressCount Integer
    The number of objects for which statistics collection is in progress.
    jobName String
    The name of the job.
    operationName String
    The name of the operation.
    startTime String
    The start time of the operation.
    status String
    The status of the Optimizer Statistics Collection task.
    target String
    The name of the target object for which statistics are gathered.
    tasks List<GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemTask>
    An array of Optimizer Statistics Collection task details.
    timedOutCount Integer
    The number of objects for which statistics collection timed out.
    totalObjectsCount Integer
    The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.
    completedCount number
    The number of objects for which statistics collection is completed.
    databases GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemDatabase[]
    The summary of the Managed Database resource.
    durationInSeconds number
    The time it takes to complete the operation (in seconds).
    endTime string
    The end time of the operation.
    failedCount number
    The number of objects for which statistics collection failed.
    id number
    The ID of the operation.
    inProgressCount number
    The number of objects for which statistics collection is in progress.
    jobName string
    The name of the job.
    operationName string
    The name of the operation.
    startTime string
    The start time of the operation.
    status string
    The status of the Optimizer Statistics Collection task.
    target string
    The name of the target object for which statistics are gathered.
    tasks GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemTask[]
    An array of Optimizer Statistics Collection task details.
    timedOutCount number
    The number of objects for which statistics collection timed out.
    totalObjectsCount number
    The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.
    completed_count int
    The number of objects for which statistics collection is completed.
    databases Sequence[GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemDatabase]
    The summary of the Managed Database resource.
    duration_in_seconds float
    The time it takes to complete the operation (in seconds).
    end_time str
    The end time of the operation.
    failed_count int
    The number of objects for which statistics collection failed.
    id int
    The ID of the operation.
    in_progress_count int
    The number of objects for which statistics collection is in progress.
    job_name str
    The name of the job.
    operation_name str
    The name of the operation.
    start_time str
    The start time of the operation.
    status str
    The status of the Optimizer Statistics Collection task.
    target str
    The name of the target object for which statistics are gathered.
    tasks Sequence[GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemTask]
    An array of Optimizer Statistics Collection task details.
    timed_out_count int
    The number of objects for which statistics collection timed out.
    total_objects_count int
    The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.
    completedCount Number
    The number of objects for which statistics collection is completed.
    databases List<Property Map>
    The summary of the Managed Database resource.
    durationInSeconds Number
    The time it takes to complete the operation (in seconds).
    endTime String
    The end time of the operation.
    failedCount Number
    The number of objects for which statistics collection failed.
    id Number
    The ID of the operation.
    inProgressCount Number
    The number of objects for which statistics collection is in progress.
    jobName String
    The name of the job.
    operationName String
    The name of the operation.
    startTime String
    The start time of the operation.
    status String
    The status of the Optimizer Statistics Collection task.
    target String
    The name of the target object for which statistics are gathered.
    tasks List<Property Map>
    An array of Optimizer Statistics Collection task details.
    timedOutCount Number
    The number of objects for which statistics collection timed out.
    totalObjectsCount Number
    The total number of objects for which statistics is collected. This number is the sum of all the objects with various statuses: completed, inProgress, failed, and timedOut.

    GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemDatabase

    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 ID of the operation.
    Name string
    The name of the Managed Database.
    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 ID of the operation.
    Name string
    The name of the Managed Database.
    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 ID of the operation.
    name String
    The name of the Managed Database.
    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 ID of the operation.
    name string
    The name of the Managed Database.
    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 ID of the operation.
    name str
    The name of the Managed Database.
    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 ID of the operation.
    name String
    The name of the Managed Database.

    GetManagedDatabaseOptimizerStatisticsCollectionOperationsOptimizerStatisticsCollectionOperationsCollectionItemTask

    Status string
    The status of the Optimizer Statistics Collection task.
    Target string
    The name of the target object for which statistics are gathered.
    TargetType string
    The type of target object.
    TimeEnd string
    The end time of the Optimizer Statistics Collection task.
    TimeStart string
    The start time of the Optimizer Statistics Collection task.
    Status string
    The status of the Optimizer Statistics Collection task.
    Target string
    The name of the target object for which statistics are gathered.
    TargetType string
    The type of target object.
    TimeEnd string
    The end time of the Optimizer Statistics Collection task.
    TimeStart string
    The start time of the Optimizer Statistics Collection task.
    status String
    The status of the Optimizer Statistics Collection task.
    target String
    The name of the target object for which statistics are gathered.
    targetType String
    The type of target object.
    timeEnd String
    The end time of the Optimizer Statistics Collection task.
    timeStart String
    The start time of the Optimizer Statistics Collection task.
    status string
    The status of the Optimizer Statistics Collection task.
    target string
    The name of the target object for which statistics are gathered.
    targetType string
    The type of target object.
    timeEnd string
    The end time of the Optimizer Statistics Collection task.
    timeStart string
    The start time of the Optimizer Statistics Collection task.
    status str
    The status of the Optimizer Statistics Collection task.
    target str
    The name of the target object for which statistics are gathered.
    target_type str
    The type of target object.
    time_end str
    The end time of the Optimizer Statistics Collection task.
    time_start str
    The start time of the Optimizer Statistics Collection task.
    status String
    The status of the Optimizer Statistics Collection task.
    target String
    The name of the target object for which statistics are gathered.
    targetType String
    The type of target object.
    timeEnd String
    The end time of the Optimizer Statistics Collection task.
    timeStart String
    The start time of the Optimizer Statistics Collection task.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci