Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getManagedDatabaseOptimizerStatisticsCollectionOperation

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

using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseOptimizerStatisticsCollectionOperation = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionOperation.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        OptimizerStatisticsCollectionOperationId = oci_database_management_optimizer_statistics_collection_operation.Test_optimizer_statistics_collection_operation.Id,
    });

});
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/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:                        oci_database_management_managed_database.Test_managed_database.Id,
			OptimizerStatisticsCollectionOperationId: oci_database_management_optimizer_statistics_collection_operation.Test_optimizer_statistics_collection_operation.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
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(oci_database_management_managed_database.test_managed_database().id())
            .optimizerStatisticsCollectionOperationId(oci_database_management_optimizer_statistics_collection_operation.test_optimizer_statistics_collection_operation().id())
            .build());

    }
}
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=oci_database_management_managed_database["test_managed_database"]["id"],
    optimizer_statistics_collection_operation_id=oci_database_management_optimizer_statistics_collection_operation["test_optimizer_statistics_collection_operation"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseOptimizerStatisticsCollectionOperation = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperation({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    optimizerStatisticsCollectionOperationId: oci_database_management_optimizer_statistics_collection_operation.test_optimizer_statistics_collection_operation.id,
});
variables:
  testManagedDatabaseOptimizerStatisticsCollectionOperation:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsCollectionOperation
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        optimizerStatisticsCollectionOperationId: ${oci_database_management_optimizer_statistics_collection_operation.test_optimizer_statistics_collection_operation.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)
// Output-based functions aren't available in Java yet
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 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 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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.