Oracle Cloud Infrastructure

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

getManagedDatabaseOptimizerStatisticsCollectionOperations

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

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseOptimizerStatisticsCollectionOperations = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsCollectionOperations.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        EndTimeLessThanOrEqualTo = @var.Managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to,
        FilterBy = @var.Managed_database_optimizer_statistics_collection_operation_filter_by,
        StartTimeGreaterThanOrEqualTo = @var.Managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to,
        TaskType = @var.Managed_database_optimizer_statistics_collection_operation_task_type,
    });

});
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.GetManagedDatabaseOptimizerStatisticsCollectionOperations(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsCollectionOperationsArgs{
			ManagedDatabaseId:             oci_database_management_managed_database.Test_managed_database.Id,
			EndTimeLessThanOrEqualTo:      pulumi.StringRef(_var.Managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to),
			FilterBy:                      pulumi.StringRef(_var.Managed_database_optimizer_statistics_collection_operation_filter_by),
			StartTimeGreaterThanOrEqualTo: pulumi.StringRef(_var.Managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to),
			TaskType:                      pulumi.StringRef(_var.Managed_database_optimizer_statistics_collection_operation_task_type),
		}, 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.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(oci_database_management_managed_database.test_managed_database().id())
            .endTimeLessThanOrEqualTo(var_.managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to())
            .filterBy(var_.managed_database_optimizer_statistics_collection_operation_filter_by())
            .startTimeGreaterThanOrEqualTo(var_.managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to())
            .taskType(var_.managed_database_optimizer_statistics_collection_operation_task_type())
            .build());

    }
}
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=oci_database_management_managed_database["test_managed_database"]["id"],
    end_time_less_than_or_equal_to=var["managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to"],
    filter_by=var["managed_database_optimizer_statistics_collection_operation_filter_by"],
    start_time_greater_than_or_equal_to=var["managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to"],
    task_type=var["managed_database_optimizer_statistics_collection_operation_task_type"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseOptimizerStatisticsCollectionOperations = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsCollectionOperations({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    endTimeLessThanOrEqualTo: _var.managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to,
    filterBy: _var.managed_database_optimizer_statistics_collection_operation_filter_by,
    startTimeGreaterThanOrEqualTo: _var.managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to,
    taskType: _var.managed_database_optimizer_statistics_collection_operation_task_type,
});
variables:
  testManagedDatabaseOptimizerStatisticsCollectionOperations:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsCollectionOperations
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        endTimeLessThanOrEqualTo: ${var.managed_database_optimizer_statistics_collection_operation_end_time_less_than_or_equal_to}
        filterBy: ${var.managed_database_optimizer_statistics_collection_operation_filter_by}
        startTimeGreaterThanOrEqualTo: ${var.managed_database_optimizer_statistics_collection_operation_start_time_greater_than_or_equal_to}
        taskType: ${var.managed_database_optimizer_statistics_collection_operation_task_type}

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[_databasemanagement.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[_databasemanagement.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)
// Output-based functions aren't available in Java yet
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 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 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 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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.