Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
oci.DatabaseManagement.getExternalExadataStorageServerTopSqlCpuActivity
Explore with Pulumi AI
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/v2/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)
public static Output<GetExternalExadataStorageServerTopSqlCpuActivityResult> getExternalExadataStorageServerTopSqlCpuActivity(GetExternalExadataStorageServerTopSqlCpuActivityArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DatabaseManagement/getExternalExadataStorageServerTopSqlCpuActivity:getExternalExadataStorageServerTopSqlCpuActivity
  arguments:
    # arguments dictionaryThe following arguments are supported:
- ExternalExadata stringStorage Server Id 
- The OCID of the Exadata storage server.
- ExternalExadata stringStorage Server Id 
- The OCID of the Exadata storage server.
- externalExadata StringStorage Server Id 
- The OCID of the Exadata storage server.
- externalExadata stringStorage Server Id 
- The OCID of the Exadata storage server.
- external_exadata_ strstorage_ server_ id 
- The OCID of the Exadata storage server.
- externalExadata StringStorage Server Id 
- The OCID of the Exadata storage server.
getExternalExadataStorageServerTopSqlCpuActivity Result
The following output properties are available:
- Activities
List<GetExternal Exadata Storage Server Top Sql Cpu Activity Activity> 
- A list of sql CPU activity.
- ExternalExadata stringStorage Server Id 
- Id string
- The provider-assigned unique ID for this managed resource.
- Activities
[]GetExternal Exadata Storage Server Top Sql Cpu Activity Activity 
- A list of sql CPU activity.
- ExternalExadata stringStorage Server Id 
- Id string
- The provider-assigned unique ID for this managed resource.
- activities
List<GetExternal Exadata Storage Server Top Sql Cpu Activity Activity> 
- A list of sql CPU activity.
- externalExadata StringStorage Server Id 
- id String
- The provider-assigned unique ID for this managed resource.
- activities
GetExternal Exadata Storage Server Top Sql Cpu Activity Activity[] 
- A list of sql CPU activity.
- externalExadata stringStorage Server Id 
- id string
- The provider-assigned unique ID for this managed resource.
- activities
Sequence[GetExternal Exadata Storage Server Top Sql Cpu Activity Activity] 
- A list of sql CPU activity.
- external_exadata_ strstorage_ server_ id 
- id str
- The provider-assigned unique ID for this managed resource.
- activities List<Property Map>
- A list of sql CPU activity.
- externalExadata StringStorage Server Id 
- 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 ociTerraform Provider.