Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi
oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript
Explore with Pulumi AI
This data source provides details about a specific Managed Database Optimizer Statistics Advisor Execution Script resource in Oracle Cloud Infrastructure Database Management service.
Gets the Oracle system-generated script for the specified Optimizer Statistics Advisor execution.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testManagedDatabaseOptimizerStatisticsAdvisorExecutionScript = oci.DatabaseManagement.getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript({
    executionName: managedDatabaseOptimizerStatisticsAdvisorExecutionScriptExecutionName,
    managedDatabaseId: testManagedDatabase.id,
    taskName: managedDatabaseOptimizerStatisticsAdvisorExecutionScriptTaskName,
});
import pulumi
import pulumi_oci as oci
test_managed_database_optimizer_statistics_advisor_execution_script = oci.DatabaseManagement.get_managed_database_optimizer_statistics_advisor_execution_script(execution_name=managed_database_optimizer_statistics_advisor_execution_script_execution_name,
    managed_database_id=test_managed_database["id"],
    task_name=managed_database_optimizer_statistics_advisor_execution_script_task_name)
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.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScript(ctx, &databasemanagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs{
			ExecutionName:     managedDatabaseOptimizerStatisticsAdvisorExecutionScriptExecutionName,
			ManagedDatabaseId: testManagedDatabase.Id,
			TaskName:          managedDatabaseOptimizerStatisticsAdvisorExecutionScriptTaskName,
		}, 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 testManagedDatabaseOptimizerStatisticsAdvisorExecutionScript = Oci.DatabaseManagement.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScript.Invoke(new()
    {
        ExecutionName = managedDatabaseOptimizerStatisticsAdvisorExecutionScriptExecutionName,
        ManagedDatabaseId = testManagedDatabase.Id,
        TaskName = managedDatabaseOptimizerStatisticsAdvisorExecutionScriptTaskName,
    });
});
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.GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs;
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 testManagedDatabaseOptimizerStatisticsAdvisorExecutionScript = DatabaseManagementFunctions.getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs.builder()
            .executionName(managedDatabaseOptimizerStatisticsAdvisorExecutionScriptExecutionName)
            .managedDatabaseId(testManagedDatabase.id())
            .taskName(managedDatabaseOptimizerStatisticsAdvisorExecutionScriptTaskName)
            .build());
    }
}
variables:
  testManagedDatabaseOptimizerStatisticsAdvisorExecutionScript:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript
      arguments:
        executionName: ${managedDatabaseOptimizerStatisticsAdvisorExecutionScriptExecutionName}
        managedDatabaseId: ${testManagedDatabase.id}
        taskName: ${managedDatabaseOptimizerStatisticsAdvisorExecutionScriptTaskName}
Using getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript
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 getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult>
function getManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptOutput(args: GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult>def get_managed_database_optimizer_statistics_advisor_execution_script(execution_name: Optional[str] = None,
                                                                       managed_database_id: Optional[str] = None,
                                                                       task_name: Optional[str] = None,
                                                                       opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult
def get_managed_database_optimizer_statistics_advisor_execution_script_output(execution_name: Optional[pulumi.Input[str]] = None,
                                                                       managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                       task_name: Optional[pulumi.Input[str]] = None,
                                                                       opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult]func GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScript(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs, opts ...InvokeOption) (*GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult, error)
func GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptOutput(ctx *Context, args *GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptOutputArgs, opts ...InvokeOption) GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResultOutput> Note: This function is named GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScript in the Go SDK.
public static class GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScript 
{
    public static Task<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult> InvokeAsync(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult> Invoke(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult> getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs args, InvokeOptions options)
public static Output<GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptResult> getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript(GetManagedDatabaseOptimizerStatisticsAdvisorExecutionScriptArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript:getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript
  arguments:
    # arguments dictionaryThe following arguments are supported:
- Execution
Name string - The name of the Optimizer Statistics Advisor execution.
 - Managed
Database stringId  - The OCID of the Managed Database.
 - Task
Name string - The name of the optimizer statistics collection execution task.
 
- Execution
Name string - The name of the Optimizer Statistics Advisor execution.
 - Managed
Database stringId  - The OCID of the Managed Database.
 - Task
Name string - The name of the optimizer statistics collection execution task.
 
- execution
Name String - The name of the Optimizer Statistics Advisor execution.
 - managed
Database StringId  - The OCID of the Managed Database.
 - task
Name String - The name of the optimizer statistics collection execution task.
 
- execution
Name string - The name of the Optimizer Statistics Advisor execution.
 - managed
Database stringId  - The OCID of the Managed Database.
 - task
Name string - The name of the optimizer statistics collection execution task.
 
- execution_
name str - The name of the Optimizer Statistics Advisor execution.
 - managed_
database_ strid  - The OCID of the Managed Database.
 - task_
name str - The name of the optimizer statistics collection execution task.
 
- execution
Name String - The name of the Optimizer Statistics Advisor execution.
 - managed
Database StringId  - The OCID of the Managed Database.
 - task
Name String - The name of the optimizer statistics collection execution task.
 
getManagedDatabaseOptimizerStatisticsAdvisorExecutionScript Result
The following output properties are available:
- Execution
Name string - Id string
 - The provider-assigned unique ID for this managed resource.
 - Managed
Database stringId  - Script string
 - The Optimizer Statistics Advisor execution script.
 - Task
Name string 
- Execution
Name string - Id string
 - The provider-assigned unique ID for this managed resource.
 - Managed
Database stringId  - Script string
 - The Optimizer Statistics Advisor execution script.
 - Task
Name string 
- execution
Name String - id String
 - The provider-assigned unique ID for this managed resource.
 - managed
Database StringId  - script String
 - The Optimizer Statistics Advisor execution script.
 - task
Name String 
- execution
Name string - id string
 - The provider-assigned unique ID for this managed resource.
 - managed
Database stringId  - script string
 - The Optimizer Statistics Advisor execution script.
 - task
Name string 
- execution_
name str - id str
 - The provider-assigned unique ID for this managed resource.
 - managed_
database_ strid  - script str
 - The Optimizer Statistics Advisor execution script.
 - task_
name str 
- execution
Name String - id String
 - The provider-assigned unique ID for this managed resource.
 - managed
Database StringId  - script String
 - The Optimizer Statistics Advisor execution script.
 - task
Name String 
Package Details
- Repository
 - oci pulumi/pulumi-oci
 - License
 - Apache-2.0
 - Notes
 - This Pulumi package is based on the 
ociTerraform Provider.