Oracle Cloud Infrastructure v2.17.0 published on Friday, Nov 15, 2024 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)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabaseTableStatistics:getManagedDatabaseTableStatistics
arguments:
# arguments dictionary
The following arguments are supported:
- Managed
Database stringId - The OCID of the Managed Database.
- Filters
List<Get
Managed Database Table Statistics Filter>
- Managed
Database stringId - The OCID of the Managed Database.
- Filters
[]Get
Managed Database Table Statistics Filter
- managed
Database StringId - The OCID of the Managed Database.
- filters
List<Get
Managed Database Table Statistics Filter>
- managed
Database stringId - The OCID of the Managed Database.
- filters
Get
Managed Database Table Statistics Filter[]
- managed_
database_ strid - The OCID of the Managed Database.
- filters
Sequence[databasemanagement.
Get Managed Database Table Statistics Filter]
- managed
Database StringId - 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.
- 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
List<Get
Managed Database Table Statistics Table Statistics Collection Item> - The list of table statistics statuses.
- Items
[]Get
Managed Database Table Statistics Table Statistics Collection Item - The list of table statistics statuses.
- items
List<Get
Managed Database Table Statistics Table Statistics Collection Item> - The list of table statistics statuses.
- items
Get
Managed Database Table Statistics Table Statistics Collection Item[] - The list of table statistics statuses.
- items
Sequence[databasemanagement.
Get Managed Database Table Statistics Table Statistics Collection Item] - The list of table statistics statuses.
- 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.