1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getExternalExadataStorageServerTopSqlCpuActivity
Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 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,
});
Copy
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"])
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.GetExternalExadataStorageServerTopSqlCpuActivity(ctx, &databasemanagement.GetExternalExadataStorageServerTopSqlCpuActivityArgs{
			ExternalExadataStorageServerId: testExternalExadataStorageServer.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 testExternalExadataStorageServerTopSqlCpuActivity = Oci.DatabaseManagement.GetExternalExadataStorageServerTopSqlCpuActivity.Invoke(new()
    {
        ExternalExadataStorageServerId = testExternalExadataStorageServer.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.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());

    }
}
Copy
variables:
  testExternalExadataStorageServerTopSqlCpuActivity:
    fn::invoke:
      function: oci:DatabaseManagement:getExternalExadataStorageServerTopSqlCpuActivity
      arguments:
        externalExadataStorageServerId: ${testExternalExadataStorageServer.id}
Copy

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>
Copy
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]
Copy
func GetExternalExadataStorageServerTopSqlCpuActivity(ctx *Context, args *GetExternalExadataStorageServerTopSqlCpuActivityArgs, opts ...InvokeOption) (*GetExternalExadataStorageServerTopSqlCpuActivityResult, error)
func GetExternalExadataStorageServerTopSqlCpuActivityOutput(ctx *Context, args *GetExternalExadataStorageServerTopSqlCpuActivityOutputArgs, opts ...InvokeOption) GetExternalExadataStorageServerTopSqlCpuActivityResultOutput
Copy

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

The following arguments are supported:

ExternalExadataStorageServerId This property is required. string
The OCID of the Exadata storage server.
ExternalExadataStorageServerId This property is required. string
The OCID of the Exadata storage server.
externalExadataStorageServerId This property is required. String
The OCID of the Exadata storage server.
externalExadataStorageServerId This property is required. string
The OCID of the Exadata storage server.
external_exadata_storage_server_id This property is required. str
The OCID of the Exadata storage server.
externalExadataStorageServerId This property is required. 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 This property is required. double
The CPU activity percentage.
DatabaseName This property is required. string
The database name.
SqlId This property is required. string
The SQL ID.
CpuActivity This property is required. float64
The CPU activity percentage.
DatabaseName This property is required. string
The database name.
SqlId This property is required. string
The SQL ID.
cpuActivity This property is required. Double
The CPU activity percentage.
databaseName This property is required. String
The database name.
sqlId This property is required. String
The SQL ID.
cpuActivity This property is required. number
The CPU activity percentage.
databaseName This property is required. string
The database name.
sqlId This property is required. string
The SQL ID.
cpu_activity This property is required. float
The CPU activity percentage.
database_name This property is required. str
The database name.
sql_id This property is required. str
The SQL ID.
cpuActivity This property is required. Number
The CPU activity percentage.
databaseName This property is required. String
The database name.
sqlId This property is required. 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.