Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
oci.DatabaseManagement.getManagedDatabaseTableStatistics
Explore with Pulumi AI
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,
});
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"])
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
})
}
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,
});
});
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());
}
}
variables:
testManagedDatabaseTableStatistics:
fn::invoke:
function: oci:DatabaseManagement:getManagedDatabaseTableStatistics
arguments:
managedDatabaseId: ${testManagedDatabase.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)
public static Output<GetManagedDatabaseTableStatisticsResult> getManagedDatabaseTableStatistics(GetManagedDatabaseTableStatisticsArgs args, InvokeOptions options)
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabaseTableStatistics:getManagedDatabaseTableStatistics
arguments:
# arguments dictionary
The following arguments are supported:
- Managed
Database Id This property is required. string - The OCID of the Managed Database.
- Filters
Changes to this property will trigger replacement.
Managed Database Table Statistics Filter>
- Managed
Database Id This property is required. string - The OCID of the Managed Database.
- Filters
Changes to this property will trigger replacement.
Managed Database Table Statistics Filter
- managed
Database Id This property is required. String - The OCID of the Managed Database.
- filters
Changes to this property will trigger replacement.
Managed Database Table Statistics Filter>
- managed
Database Id This property is required. string - The OCID of the Managed Database.
- filters
Changes to this property will trigger replacement.
Managed Database Table Statistics Filter[]
- managed_
database_ id This property is required. str - The OCID of the Managed Database.
- filters
Changes to this property will trigger replacement.
Get Managed Database Table Statistics Filter]
- managed
Database Id This property is required. String - The OCID of the Managed Database.
- filters
Changes to this property will trigger replacement.
getManagedDatabaseTableStatistics Result
The following output properties are available:
- Id string
- The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Table
Statistics List<GetCollections Managed Database Table Statistics Table Statistics Collection> - The list of table_statistics_collection.
- Filters
List<Get
Managed Database Table Statistics Filter>
- Id string
- The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Table
Statistics []GetCollections Managed Database Table Statistics Table Statistics Collection - The list of table_statistics_collection.
- Filters
[]Get
Managed Database Table Statistics Filter
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - table
Statistics List<GetCollections Managed Database Table Statistics Table Statistics Collection> - The list of table_statistics_collection.
- filters
List<Get
Managed Database Table Statistics Filter>
- id string
- The provider-assigned unique ID for this managed resource.
- managed
Database stringId - table
Statistics GetCollections Managed Database Table Statistics Table Statistics Collection[] - The list of table_statistics_collection.
- filters
Get
Managed Database Table Statistics Filter[]
- id str
- The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - table_
statistics_ Sequence[databasemanagement.collections Get Managed Database Table Statistics Table Statistics Collection] - The list of table_statistics_collection.
- filters
Sequence[databasemanagement.
Get Managed Database Table Statistics Filter]
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - table
Statistics List<Property Map>Collections - The list of table_statistics_collection.
- filters List<Property Map>
Supporting Types
GetManagedDatabaseTableStatisticsFilter
GetManagedDatabaseTableStatisticsTableStatisticsCollection
- Items
This property is required. List<GetManaged Database Table Statistics Table Statistics Collection Item> - The list of table statistics statuses.
- Items
This property is required. []GetManaged Database Table Statistics Table Statistics Collection Item - The list of table statistics statuses.
- items
This property is required. List<GetManaged Database Table Statistics Table Statistics Collection Item> - The list of table statistics statuses.
- items
This property is required. GetManaged Database Table Statistics Table Statistics Collection Item[] - The list of table statistics statuses.
- items
This property is required. Sequence[databasemanagement.Get Managed Database Table Statistics Table Statistics Collection Item] - 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.