1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseTableStatistics
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseTableStatistics

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 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: testManagedDatabase.id,
});
Copy
import pulumi
import pulumi_oci as oci

test_managed_database_table_statistics = oci.DatabaseManagement.get_managed_database_table_statistics(managed_database_id=test_managed_database["id"])
Copy
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.GetManagedDatabaseTableStatistics(ctx, &databasemanagement.GetManagedDatabaseTableStatisticsArgs{
			ManagedDatabaseId: testManagedDatabase.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
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 = testManagedDatabase.Id,
    });

});
Copy
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(testManagedDatabase.id())
            .build());

    }
}
Copy
variables:
  testManagedDatabaseTableStatistics:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseTableStatistics
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
Copy

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>
Copy
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]
Copy
func GetManagedDatabaseTableStatistics(ctx *Context, args *GetManagedDatabaseTableStatisticsArgs, opts ...InvokeOption) (*GetManagedDatabaseTableStatisticsResult, error)
func GetManagedDatabaseTableStatisticsOutput(ctx *Context, args *GetManagedDatabaseTableStatisticsOutputArgs, opts ...InvokeOption) GetManagedDatabaseTableStatisticsResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetManagedDatabaseTableStatisticsResult> getManagedDatabaseTableStatistics(GetManagedDatabaseTableStatisticsArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseTableStatisticsResult> getManagedDatabaseTableStatistics(GetManagedDatabaseTableStatisticsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseTableStatistics:getManagedDatabaseTableStatistics
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ManagedDatabaseId This property is required. string
The OCID of the Managed Database.
Filters Changes to this property will trigger replacement. List<GetManagedDatabaseTableStatisticsFilter>
ManagedDatabaseId This property is required. string
The OCID of the Managed Database.
Filters Changes to this property will trigger replacement. []GetManagedDatabaseTableStatisticsFilter
managedDatabaseId This property is required. String
The OCID of the Managed Database.
filters Changes to this property will trigger replacement. List<GetManagedDatabaseTableStatisticsFilter>
managedDatabaseId This property is required. string
The OCID of the Managed Database.
filters Changes to this property will trigger replacement. GetManagedDatabaseTableStatisticsFilter[]
managed_database_id This property is required. str
The OCID of the Managed Database.
filters Changes to this property will trigger replacement. Sequence[databasemanagement.GetManagedDatabaseTableStatisticsFilter]
managedDatabaseId This property is required. String
The OCID of the Managed Database.
filters Changes to this property will trigger replacement. 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 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 This property is required. string
Values This property is required. List<string>
Regex bool
Name This property is required. string
Values This property is required. []string
Regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean
name This property is required. string
values This property is required. string[]
regex boolean
name This property is required. str
values This property is required. Sequence[str]
regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean

GetManagedDatabaseTableStatisticsTableStatisticsCollection

Items This property is required. List<GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem>
The list of table statistics statuses.
Items This property is required. []GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem
The list of table statistics statuses.
items This property is required. List<GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem>
The list of table statistics statuses.
items This property is required. GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem[]
The list of table statistics statuses.
items This property is required. Sequence[databasemanagement.GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem]
The list of table statistics statuses.
items This property is required. List<Property Map>
The list of table statistics statuses.

GetManagedDatabaseTableStatisticsTableStatisticsCollectionItem

Count This property is required. int
The number of objects aggregated by status category.
Percentage This property is required. double
The percentage of objects with a particular status.
Type This property is required. string
The valid status categories of table statistics.
Count This property is required. int
The number of objects aggregated by status category.
Percentage This property is required. float64
The percentage of objects with a particular status.
Type This property is required. string
The valid status categories of table statistics.
count This property is required. Integer
The number of objects aggregated by status category.
percentage This property is required. Double
The percentage of objects with a particular status.
type This property is required. String
The valid status categories of table statistics.
count This property is required. number
The number of objects aggregated by status category.
percentage This property is required. number
The percentage of objects with a particular status.
type This property is required. string
The valid status categories of table statistics.
count This property is required. int
The number of objects aggregated by status category.
percentage This property is required. float
The percentage of objects with a particular status.
type This property is required. str
The valid status categories of table statistics.
count This property is required. Number
The number of objects aggregated by status category.
percentage This property is required. Number
The percentage of objects with a particular status.
type This property is required. 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.
Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi