Oracle Cloud Infrastructure v2.28.0, Mar 27 25

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperation

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

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.

TypeScript
Python
Go
C#
Java
YAML

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[databasemanagement.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[databasemanagement.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.

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperation

On this page

On this page

Example Usage

Using getManagedDatabaseOptimizerStatisticsCollectionOperation

getManagedDatabaseOptimizerStatisticsCollectionOperation Result

Supporting Types

GetManagedDatabaseOptimizerStatisticsCollectionOperationDatabase

GetManagedDatabaseOptimizerStatisticsCollectionOperationTask

Package Details

On this page

On this page