Viewing docs for Oracle Cloud Infrastructure v3.16.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
published on Monday, Mar 9, 2026 by Pulumi
Viewing docs for Oracle Cloud Infrastructure v3.16.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
published on Monday, Mar 9, 2026 by Pulumi
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/v3/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.
Viewing docs for Oracle Cloud Infrastructure v3.16.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
published on Monday, Mar 9, 2026 by Pulumi
