1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getExternalExadataStorageServerTopSqlCpuActivity
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.DatabaseManagement.getExternalExadataStorageServerTopSqlCpuActivity

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

    This data source provides details about a specific External Exadata Storage Server Top Sql Cpu Activity resource in Oracle Cloud Infrastructure Database Management service.

    Gets the SQL IDs with the top CPU activity from the Exadata storage server.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testExternalExadataStorageServerTopSqlCpuActivity = oci.DatabaseManagement.getExternalExadataStorageServerTopSqlCpuActivity({
        externalExadataStorageServerId: testExternalExadataStorageServer.id,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_external_exadata_storage_server_top_sql_cpu_activity = oci.DatabaseManagement.get_external_exadata_storage_server_top_sql_cpu_activity(external_exadata_storage_server_id=test_external_exadata_storage_server["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.GetExternalExadataStorageServerTopSqlCpuActivity(ctx, &databasemanagement.GetExternalExadataStorageServerTopSqlCpuActivityArgs{
    			ExternalExadataStorageServerId: testExternalExadataStorageServer.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 testExternalExadataStorageServerTopSqlCpuActivity = Oci.DatabaseManagement.GetExternalExadataStorageServerTopSqlCpuActivity.Invoke(new()
        {
            ExternalExadataStorageServerId = testExternalExadataStorageServer.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.GetExternalExadataStorageServerTopSqlCpuActivityArgs;
    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 testExternalExadataStorageServerTopSqlCpuActivity = DatabaseManagementFunctions.getExternalExadataStorageServerTopSqlCpuActivity(GetExternalExadataStorageServerTopSqlCpuActivityArgs.builder()
                .externalExadataStorageServerId(testExternalExadataStorageServer.id())
                .build());
    
        }
    }
    
    variables:
      testExternalExadataStorageServerTopSqlCpuActivity:
        fn::invoke:
          Function: oci:DatabaseManagement:getExternalExadataStorageServerTopSqlCpuActivity
          Arguments:
            externalExadataStorageServerId: ${testExternalExadataStorageServer.id}
    

    Using getExternalExadataStorageServerTopSqlCpuActivity

    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 getExternalExadataStorageServerTopSqlCpuActivity(args: GetExternalExadataStorageServerTopSqlCpuActivityArgs, opts?: InvokeOptions): Promise<GetExternalExadataStorageServerTopSqlCpuActivityResult>
    function getExternalExadataStorageServerTopSqlCpuActivityOutput(args: GetExternalExadataStorageServerTopSqlCpuActivityOutputArgs, opts?: InvokeOptions): Output<GetExternalExadataStorageServerTopSqlCpuActivityResult>
    def get_external_exadata_storage_server_top_sql_cpu_activity(external_exadata_storage_server_id: Optional[str] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> GetExternalExadataStorageServerTopSqlCpuActivityResult
    def get_external_exadata_storage_server_top_sql_cpu_activity_output(external_exadata_storage_server_id: Optional[pulumi.Input[str]] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> Output[GetExternalExadataStorageServerTopSqlCpuActivityResult]
    func GetExternalExadataStorageServerTopSqlCpuActivity(ctx *Context, args *GetExternalExadataStorageServerTopSqlCpuActivityArgs, opts ...InvokeOption) (*GetExternalExadataStorageServerTopSqlCpuActivityResult, error)
    func GetExternalExadataStorageServerTopSqlCpuActivityOutput(ctx *Context, args *GetExternalExadataStorageServerTopSqlCpuActivityOutputArgs, opts ...InvokeOption) GetExternalExadataStorageServerTopSqlCpuActivityResultOutput

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

    public static class GetExternalExadataStorageServerTopSqlCpuActivity 
    {
        public static Task<GetExternalExadataStorageServerTopSqlCpuActivityResult> InvokeAsync(GetExternalExadataStorageServerTopSqlCpuActivityArgs args, InvokeOptions? opts = null)
        public static Output<GetExternalExadataStorageServerTopSqlCpuActivityResult> Invoke(GetExternalExadataStorageServerTopSqlCpuActivityInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetExternalExadataStorageServerTopSqlCpuActivityResult> getExternalExadataStorageServerTopSqlCpuActivity(GetExternalExadataStorageServerTopSqlCpuActivityArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getExternalExadataStorageServerTopSqlCpuActivity:getExternalExadataStorageServerTopSqlCpuActivity
      arguments:
        # arguments dictionary

    The following arguments are supported:

    ExternalExadataStorageServerId string
    The OCID of the Exadata storage server.
    ExternalExadataStorageServerId string
    The OCID of the Exadata storage server.
    externalExadataStorageServerId String
    The OCID of the Exadata storage server.
    externalExadataStorageServerId string
    The OCID of the Exadata storage server.
    external_exadata_storage_server_id str
    The OCID of the Exadata storage server.
    externalExadataStorageServerId String
    The OCID of the Exadata storage server.

    getExternalExadataStorageServerTopSqlCpuActivity Result

    The following output properties are available:

    Activities List<GetExternalExadataStorageServerTopSqlCpuActivityActivity>
    A list of sql CPU activity.
    ExternalExadataStorageServerId string
    Id string
    The provider-assigned unique ID for this managed resource.
    Activities []GetExternalExadataStorageServerTopSqlCpuActivityActivity
    A list of sql CPU activity.
    ExternalExadataStorageServerId string
    Id string
    The provider-assigned unique ID for this managed resource.
    activities List<GetExternalExadataStorageServerTopSqlCpuActivityActivity>
    A list of sql CPU activity.
    externalExadataStorageServerId String
    id String
    The provider-assigned unique ID for this managed resource.
    activities GetExternalExadataStorageServerTopSqlCpuActivityActivity[]
    A list of sql CPU activity.
    externalExadataStorageServerId string
    id string
    The provider-assigned unique ID for this managed resource.
    activities Sequence[databasemanagement.GetExternalExadataStorageServerTopSqlCpuActivityActivity]
    A list of sql CPU activity.
    external_exadata_storage_server_id str
    id str
    The provider-assigned unique ID for this managed resource.
    activities List<Property Map>
    A list of sql CPU activity.
    externalExadataStorageServerId String
    id String
    The provider-assigned unique ID for this managed resource.

    Supporting Types

    GetExternalExadataStorageServerTopSqlCpuActivityActivity

    CpuActivity double
    The CPU activity percentage.
    DatabaseName string
    The database name.
    SqlId string
    The SQL ID.
    CpuActivity float64
    The CPU activity percentage.
    DatabaseName string
    The database name.
    SqlId string
    The SQL ID.
    cpuActivity Double
    The CPU activity percentage.
    databaseName String
    The database name.
    sqlId String
    The SQL ID.
    cpuActivity number
    The CPU activity percentage.
    databaseName string
    The database name.
    sqlId string
    The SQL ID.
    cpu_activity float
    The CPU activity percentage.
    database_name str
    The database name.
    sql_id str
    The SQL ID.
    cpuActivity Number
    The CPU activity percentage.
    databaseName String
    The database name.
    sqlId String
    The SQL ID.

    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.41.0 published on Wednesday, Jun 19, 2024 by Pulumi