1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseTableStatistics
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseTableStatistics

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

    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

    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,
    });
    
    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"])
    
    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
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    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 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());
    
        }
    }
    
    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
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi