Oracle Cloud Infrastructure

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

getManagedDatabaseTableStatistics

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

Gets the number of database table objects grouped by different statuses such as Not Stale Stats, Stale Stats, and No Stats. This also includes the percentage of each status.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseTableStatistics = Oci.DatabaseManagement.GetManagedDatabaseTableStatistics.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.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.GetManagedDatabaseTableStatistics(ctx, &databasemanagement.GetManagedDatabaseTableStatisticsArgs{
			ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.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.GetManagedDatabaseTableStatisticsArgs;
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 testManagedDatabaseTableStatistics = DatabaseManagementFunctions.getManagedDatabaseTableStatistics(GetManagedDatabaseTableStatisticsArgs.builder()
            .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_managed_database_table_statistics = oci.DatabaseManagement.get_managed_database_table_statistics(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseTableStatistics = oci.DatabaseManagement.getManagedDatabaseTableStatistics({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
});
variables:
  testManagedDatabaseTableStatistics:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseTableStatistics
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}

Using getManagedDatabaseTableStatistics

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 getManagedDatabaseTableStatistics(args: GetManagedDatabaseTableStatisticsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseTableStatisticsResult>
function getManagedDatabaseTableStatisticsOutput(args: GetManagedDatabaseTableStatisticsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseTableStatisticsResult>
def get_managed_database_table_statistics(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseTableStatisticsFilter]] = None,
                                          managed_database_id: Optional[str] = None,
                                          opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseTableStatisticsResult
def get_managed_database_table_statistics_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseTableStatisticsFilterArgs]]]] = None,
                                          managed_database_id: Optional[pulumi.Input[str]] = None,
                                          opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseTableStatisticsResult]
func GetManagedDatabaseTableStatistics(ctx *Context, args *GetManagedDatabaseTableStatisticsArgs, opts ...InvokeOption) (*GetManagedDatabaseTableStatisticsResult, error)
func GetManagedDatabaseTableStatisticsOutput(ctx *Context, args *GetManagedDatabaseTableStatisticsOutputArgs, opts ...InvokeOption) GetManagedDatabaseTableStatisticsResultOutput

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

public static class GetManagedDatabaseTableStatistics 
{
    public static Task<GetManagedDatabaseTableStatisticsResult> InvokeAsync(GetManagedDatabaseTableStatisticsArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseTableStatisticsResult> Invoke(GetManagedDatabaseTableStatisticsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseTableStatisticsResult> getManagedDatabaseTableStatistics(GetManagedDatabaseTableStatisticsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseTableStatistics:getManagedDatabaseTableStatistics
  Arguments:
    # Arguments dictionary

The following arguments are supported:

managedDatabaseId String

The OCID of the Managed Database.

filters List<Property Map>

getManagedDatabaseTableStatistics Result

The following output properties are available:

Id string

The provider-assigned unique ID for this managed resource.

ManagedDatabaseId string
TableStatisticsCollections List<GetManagedDatabaseTableStatisticsTableStatisticsCollection>

The list of table_statistics_collection.

Filters List<GetManagedDatabaseTableStatisticsFilter>
Id string

The provider-assigned unique ID for this managed resource.

ManagedDatabaseId string
TableStatisticsCollections []GetManagedDatabaseTableStatisticsTableStatisticsCollection

The list of table_statistics_collection.

Filters []GetManagedDatabaseTableStatisticsFilter
id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
tableStatisticsCollections List<GetManagedDatabaseTableStatisticsTableStatisticsCollection>

The list of table_statistics_collection.

filters List<GetManagedDatabaseTableStatisticsFilter>
id string

The provider-assigned unique ID for this managed resource.

managedDatabaseId string
tableStatisticsCollections GetManagedDatabaseTableStatisticsTableStatisticsCollection[]

The list of table_statistics_collection.

filters GetManagedDatabaseTableStatisticsFilter[]
id str

The provider-assigned unique ID for this managed resource.

managed_database_id str
table_statistics_collections GetManagedDatabaseTableStatisticsTableStatisticsCollection]

The list of table_statistics_collection.

filters GetManagedDatabaseTableStatisticsFilter]
id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
tableStatisticsCollections List<Property Map>

The list of table_statistics_collection.

filters List<Property Map>

Supporting Types

GetManagedDatabaseTableStatisticsFilter

Name string
Values List<string>
Regex bool
Name string
Values []string
Regex bool
name String
values List<String>
regex Boolean
name string
values string[]
regex boolean
name str
values Sequence[str]
regex bool
name String
values List<String>
regex Boolean

GetManagedDatabaseTableStatisticsTableStatisticsCollection

items List<Property Map>

The list of table statistics statuses.

GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem

Count int

The number of objects aggregated by status category.

Percentage double

The percentage of objects with a particular status.

Type string

The valid status categories of table statistics.

Count int

The number of objects aggregated by status category.

Percentage float64

The percentage of objects with a particular status.

Type string

The valid status categories of table statistics.

count Integer

The number of objects aggregated by status category.

percentage Double

The percentage of objects with a particular status.

type String

The valid status categories of table statistics.

count number

The number of objects aggregated by status category.

percentage number

The percentage of objects with a particular status.

type string

The valid status categories of table statistics.

count int

The number of objects aggregated by status category.

percentage float

The percentage of objects with a particular status.

type str

The valid status categories of table statistics.

count Number

The number of objects aggregated by status category.

percentage Number

The percentage of objects with a particular status.

type String

The valid status categories of table statistics.

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.