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

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperation

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 details about a specific Managed Database Optimizer Statistics Collection Operation resource in Oracle Cloud Infrastructure Database Management service.

    Gets a detailed report of the Optimizer Statistics Collection operation for the specified Managed Database.

    Example Usage

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

const testManagedDatabaseOptimizerStatisticsCollectionOperation = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperation({
    managedDatabaseId: testManagedDatabase.id,
    optimizerStatisticsCollectionOperationId: testOptimizerStatisticsCollectionOperation.id,
});

    import pulumi
import pulumi_oci as oci

test_managed_database_optimizer_statistics_collection_operation = oci.DatabaseManagement.get_managed_database_optimizer_statistics_collection_operation(managed_database_id=test_managed_database["id"],
    optimizer_statistics_collection_operation_id=test_optimizer_statistics_collection_operation["id"])

    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.GetManagedDatabaseOptimizerStatisticsCollectionOperation(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs{
			ManagedDatabaseId:                        testManagedDatabase.Id,
			OptimizerStatisticsCollectionOperationId: testOptimizerStatisticsCollectionOperation.Id,
		}, 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 testManagedDatabaseOptimizerStatisticsCollectionOperation = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionOperation.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        OptimizerStatisticsCollectionOperationId = testOptimizerStatisticsCollectionOperation.Id,
    });

});

    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.GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs;
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 testManagedDatabaseOptimizerStatisticsCollectionOperation = DatabaseManagementFunctions.getManagedDatabaseOptimizerStatisticsCollectionOperation(GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .optimizerStatisticsCollectionOperationId(testOptimizerStatisticsCollectionOperation.id())
            .build());

    }
}

    variables:
  testManagedDatabaseOptimizerStatisticsCollectionOperation:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsCollectionOperation
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        optimizerStatisticsCollectionOperationId: ${testOptimizerStatisticsCollectionOperation.id}

    Using getManagedDatabaseOptimizerStatisticsCollectionOperation

    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 getManagedDatabaseOptimizerStatisticsCollectionOperation(args: GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseOptimizerStatisticsCollectionOperationResult>
function getManagedDatabaseOptimizerStatisticsCollectionOperationOutput(args: GetManagedDatabaseOptimizerStatisticsCollectionOperationOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseOptimizerStatisticsCollectionOperationResult>
    def get_managed_database_optimizer_statistics_collection_operation(managed_database_id: Optional[str] = None,
                                                                   optimizer_statistics_collection_operation_id: Optional[float] = None,
                                                                   opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseOptimizerStatisticsCollectionOperationResult
def get_managed_database_optimizer_statistics_collection_operation_output(managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                   optimizer_statistics_collection_operation_id: Optional[pulumi.Input[float]] = None,
                                                                   opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseOptimizerStatisticsCollectionOperationResult]
    func GetManagedDatabaseOptimizerStatisticsCollectionOperation(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs, opts ...InvokeOption) (*GetManagedDatabaseOptimizerStatisticsCollectionOperationResult, error)
func GetManagedDatabaseOptimizerStatisticsCollectionOperationOutput(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsCollectionOperationOutputArgs, opts ...InvokeOption) GetManagedDatabaseOptimizerStatisticsCollectionOperationResultOutput

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

    public static class GetManagedDatabaseOptimizerStatisticsCollectionOperation 
{
    public static Task<GetManagedDatabaseOptimizerStatisticsCollectionOperationResult> InvokeAsync(GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseOptimizerStatisticsCollectionOperationResult> Invoke(GetManagedDatabaseOptimizerStatisticsCollectionOperationInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedDatabaseOptimizerStatisticsCollectionOperationResult> getManagedDatabaseOptimizerStatisticsCollectionOperation(GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseOptimizerStatisticsCollectionOperationResult> getManagedDatabaseOptimizerStatisticsCollectionOperation(GetManagedDatabaseOptimizerStatisticsCollectionOperationArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseOptimizerStatisticsCollectionOperation:getManagedDatabaseOptimizerStatisticsCollectionOperation
  arguments:
    # arguments dictionary

    The following arguments are supported:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    OptimizerStatisticsCollectionOperationId double
    The ID of the Optimizer Statistics Collection operation.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    OptimizerStatisticsCollectionOperationId float64
    The ID of the Optimizer Statistics Collection operation.
    managedDatabaseId String
    The OCID of the Managed Database.
    optimizerStatisticsCollectionOperationId Double
    The ID of the Optimizer Statistics Collection operation.
    managedDatabaseId string
    The OCID of the Managed Database.
    optimizerStatisticsCollectionOperationId number
    The ID of the Optimizer Statistics Collection operation.
    managed_database_id str
    The OCID of the Managed Database.
    optimizer_statistics_collection_operation_id float
    The ID of the Optimizer Statistics Collection operation.
    managedDatabaseId String
    The OCID of the Managed Database.
    optimizerStatisticsCollectionOperationId Number
    The ID of the Optimizer Statistics Collection operation.

    getManagedDatabaseOptimizerStatisticsCollectionOperation Result

    The following output properties are available:

    CompletedCount int
    The number of objects for which statistics collection is completed.
    Databases List<GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase>
    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 string
    The provider-assigned unique ID for this managed resource.
    InProgressCount int
    The number of objects for which statistics collection is in progress.
    JobName string
    The name of the job.
    ManagedDatabaseId string
    OperationName string
    The name of the operation.
    OptimizerStatisticsCollectionOperationId double
    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<GetManagedDatabaseOptimizerStatisticsCollectionOperationTask>
    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 []GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase
    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 string
    The provider-assigned unique ID for this managed resource.
    InProgressCount int
    The number of objects for which statistics collection is in progress.
    JobName string
    The name of the job.
    ManagedDatabaseId string
    OperationName string
    The name of the operation.
    OptimizerStatisticsCollectionOperationId float64
    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 []GetManagedDatabaseOptimizerStatisticsCollectionOperationTask
    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<GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase>
    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 String
    The provider-assigned unique ID for this managed resource.
    inProgressCount Integer
    The number of objects for which statistics collection is in progress.
    jobName String
    The name of the job.
    managedDatabaseId String
    operationName String
    The name of the operation.
    optimizerStatisticsCollectionOperationId Double
    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<GetManagedDatabaseOptimizerStatisticsCollectionOperationTask>
    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 GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase[]
    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 string
    The provider-assigned unique ID for this managed resource.
    inProgressCount number
    The number of objects for which statistics collection is in progress.
    jobName string
    The name of the job.
    managedDatabaseId string
    operationName string
    The name of the operation.
    optimizerStatisticsCollectionOperationId number
    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 GetManagedDatabaseOptimizerStatisticsCollectionOperationTask[]
    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[GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase]
    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 str
    The provider-assigned unique ID for this managed resource.
    in_progress_count int
    The number of objects for which statistics collection is in progress.
    job_name str
    The name of the job.
    managed_database_id str
    operation_name str
    The name of the operation.
    optimizer_statistics_collection_operation_id float
    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[GetManagedDatabaseOptimizerStatisticsCollectionOperationTask]
    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 String
    The provider-assigned unique ID for this managed resource.
    inProgressCount Number
    The number of objects for which statistics collection is in progress.
    jobName String
    The name of the job.
    managedDatabaseId String
    operationName String
    The name of the operation.
    optimizerStatisticsCollectionOperationId Number
    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.

    Supporting Types

    GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase

    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.

    GetManagedDatabaseOptimizerStatisticsCollectionOperationTask

    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