Oracle Cloud Infrastructure
getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Summary Report resource in Oracle Cloud Infrastructure Database Management service.
Gets the summary report for the specified SQL Tuning Advisor task.
Example Usage
using Pulumi;
using Oci = Pulumi.Oci;
class MyStack : Stack
{
public MyStack()
{
var testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs
{
ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
SqlTuningAdvisorTaskId = oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
BeginExecIdGreaterThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to,
EndExecIdLessThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to,
SearchPeriod = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_search_period,
TimeGreaterThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to,
TimeLessThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to,
}));
}
}
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.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs{
ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.Id,
SqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
BeginExecIdGreaterThanOrEqualTo: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to),
EndExecIdLessThanOrEqualTo: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to),
SearchPeriod: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_search_period),
TimeGreaterThanOrEqualTo: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to),
TimeLessThanOrEqualTo: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to),
}, nil)
if err != nil {
return err
}
return nil
})
}
Coming soon!
import pulumi
import pulumi_oci as oci
test_managed_database_sql_tuning_advisor_tasks_summary_report = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_summary_report(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
sql_tuning_advisor_task_id=oci_database_management_sql_tuning_advisor_task["test_sql_tuning_advisor_task"]["id"],
begin_exec_id_greater_than_or_equal_to=var["managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to"],
end_exec_id_less_than_or_equal_to=var["managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to"],
search_period=var["managed_database_sql_tuning_advisor_tasks_summary_report_search_period"],
time_greater_than_or_equal_to=var["managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to"],
time_less_than_or_equal_to=var["managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport({
managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
sqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id,
beginExecIdGreaterThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to,
endExecIdLessThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to,
searchPeriod: _var.managed_database_sql_tuning_advisor_tasks_summary_report_search_period,
timeGreaterThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to,
timeLessThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to,
});
Coming soon!
Using getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
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 getManagedDatabaseSqlTuningAdvisorTasksSummaryReport(args: GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult>
function getManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult>
def get_managed_database_sql_tuning_advisor_tasks_summary_report(begin_exec_id_greater_than_or_equal_to: Optional[str] = None,
end_exec_id_less_than_or_equal_to: Optional[str] = None,
managed_database_id: Optional[str] = None,
search_period: Optional[str] = None,
sql_tuning_advisor_task_id: Optional[str] = None,
time_greater_than_or_equal_to: Optional[str] = None,
time_less_than_or_equal_to: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult
def get_managed_database_sql_tuning_advisor_tasks_summary_report_output(begin_exec_id_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
end_exec_id_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
managed_database_id: Optional[pulumi.Input[str]] = None,
search_period: Optional[pulumi.Input[str]] = None,
sql_tuning_advisor_task_id: Optional[pulumi.Input[str]] = None,
time_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
time_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult]
func GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResultOutput
> Note: This function is named GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport
in the Go SDK.
public static class GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport
{
public static Task<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs args, InvokeOptions? opts = null)
public static Output<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult> getManagedDatabaseSqlTuningAdvisorTasksSummaryReport(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
Function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksSummaryReport:getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
Arguments:
# Arguments dictionary
The following arguments are supported:
- Managed
Database stringId The OCID of the Managed Database.
- Sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- Begin
Exec stringId Greater Than Or Equal To The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- End
Exec stringId Less Than Or Equal To The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- Search
Period string How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
- Time
Greater stringThan Or Equal To The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- Time
Less stringThan Or Equal To The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- Managed
Database stringId The OCID of the Managed Database.
- Sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- Begin
Exec stringId Greater Than Or Equal To The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- End
Exec stringId Less Than Or Equal To The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- Search
Period string How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
- Time
Greater stringThan Or Equal To The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- Time
Less stringThan Or Equal To The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- managed
Database StringId The OCID of the Managed Database.
- sql
Tuning StringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- begin
Exec StringId Greater Than Or Equal To The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- end
Exec StringId Less Than Or Equal To The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- search
Period String How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
- time
Greater StringThan Or Equal To The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- time
Less StringThan Or Equal To The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- managed
Database stringId The OCID of the Managed Database.
- sql
Tuning stringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- begin
Exec stringId Greater Than Or Equal To The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- end
Exec stringId Less Than Or Equal To The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- search
Period string How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
- time
Greater stringThan Or Equal To The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- time
Less stringThan Or Equal To The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- managed_
database_ strid The OCID of the Managed Database.
- sql_
tuning_ stradvisor_ task_ id The SQL tuning task identifier. This is not the OCID.
- begin_
exec_ strid_ greater_ than_ or_ equal_ to The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- end_
exec_ strid_ less_ than_ or_ equal_ to The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- search_
period str How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
- time_
greater_ strthan_ or_ equal_ to The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- time_
less_ strthan_ or_ equal_ to The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- managed
Database StringId The OCID of the Managed Database.
- sql
Tuning StringAdvisor Task Id The SQL tuning task identifier. This is not the OCID.
- begin
Exec StringId Greater Than Or Equal To The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- end
Exec StringId Less Than Or Equal To The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
- search
Period String How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
- time
Greater StringThan Or Equal To The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
- time
Less StringThan Or Equal To The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
getManagedDatabaseSqlTuningAdvisorTasksSummaryReport Result
The following output properties are available:
- Id string
The provider-assigned unique ID for this managed resource.
- Index
Findings List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Index Finding> The list of object findings related to indexes.
- Managed
Database stringId - Object
Stat List<GetFindings Managed Database Sql Tuning Advisor Tasks Summary Report Object Stat Finding> The list of object findings related to statistics.
- Sql
Tuning stringAdvisor Task Id - Statistics
List<Get
Managed Database Sql Tuning Advisor Tasks Summary Report Statistic> The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- Task
Infos List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Task Info> The general information regarding the SQL Tuning Advisor task.
- Begin
Exec stringId Greater Than Or Equal To - End
Exec stringId Less Than Or Equal To - Search
Period string - Time
Greater stringThan Or Equal To - Time
Less stringThan Or Equal To
- Id string
The provider-assigned unique ID for this managed resource.
- Index
Findings []GetManaged Database Sql Tuning Advisor Tasks Summary Report Index Finding The list of object findings related to indexes.
- Managed
Database stringId - Object
Stat []GetFindings Managed Database Sql Tuning Advisor Tasks Summary Report Object Stat Finding The list of object findings related to statistics.
- Sql
Tuning stringAdvisor Task Id - Statistics
[]Get
Managed Database Sql Tuning Advisor Tasks Summary Report Statistic The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- Task
Infos []GetManaged Database Sql Tuning Advisor Tasks Summary Report Task Info The general information regarding the SQL Tuning Advisor task.
- Begin
Exec stringId Greater Than Or Equal To - End
Exec stringId Less Than Or Equal To - Search
Period string - Time
Greater stringThan Or Equal To - Time
Less stringThan Or Equal To
- id String
The provider-assigned unique ID for this managed resource.
- index
Findings List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Index Finding> The list of object findings related to indexes.
- managed
Database StringId - object
Stat List<GetFindings Managed Database Sql Tuning Advisor Tasks Summary Report Object Stat Finding> The list of object findings related to statistics.
- sql
Tuning StringAdvisor Task Id - statistics
List<Get
Managed Database Sql Tuning Advisor Tasks Summary Report Statistic> The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- task
Infos List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Task Info> The general information regarding the SQL Tuning Advisor task.
- begin
Exec StringId Greater Than Or Equal To - end
Exec StringId Less Than Or Equal To - search
Period String - time
Greater StringThan Or Equal To - time
Less StringThan Or Equal To
- id string
The provider-assigned unique ID for this managed resource.
- index
Findings GetManaged Database Sql Tuning Advisor Tasks Summary Report Index Finding[] The list of object findings related to indexes.
- managed
Database stringId - object
Stat GetFindings Managed Database Sql Tuning Advisor Tasks Summary Report Object Stat Finding[] The list of object findings related to statistics.
- sql
Tuning stringAdvisor Task Id - statistics
Get
Managed Database Sql Tuning Advisor Tasks Summary Report Statistic[] The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- task
Infos GetManaged Database Sql Tuning Advisor Tasks Summary Report Task Info[] The general information regarding the SQL Tuning Advisor task.
- begin
Exec stringId Greater Than Or Equal To - end
Exec stringId Less Than Or Equal To - search
Period string - time
Greater stringThan Or Equal To - time
Less stringThan Or Equal To
- id str
The provider-assigned unique ID for this managed resource.
- index_
findings GetManaged Database Sql Tuning Advisor Tasks Summary Report Index Finding] The list of object findings related to indexes.
- managed_
database_ strid - object_
stat_ Getfindings Managed Database Sql Tuning Advisor Tasks Summary Report Object Stat Finding] The list of object findings related to statistics.
- sql_
tuning_ stradvisor_ task_ id - statistics
Get
Managed Database Sql Tuning Advisor Tasks Summary Report Statistic] The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- task_
infos GetManaged Database Sql Tuning Advisor Tasks Summary Report Task Info] The general information regarding the SQL Tuning Advisor task.
- begin_
exec_ strid_ greater_ than_ or_ equal_ to - end_
exec_ strid_ less_ than_ or_ equal_ to - search_
period str - time_
greater_ strthan_ or_ equal_ to - time_
less_ strthan_ or_ equal_ to
- id String
The provider-assigned unique ID for this managed resource.
- index
Findings List<Property Map> The list of object findings related to indexes.
- managed
Database StringId - object
Stat List<Property Map>Findings The list of object findings related to statistics.
- sql
Tuning StringAdvisor Task Id - statistics List<Property Map>
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- task
Infos List<Property Map> The general information regarding the SQL Tuning Advisor task.
- begin
Exec StringId Greater Than Or Equal To - end
Exec StringId Less Than Or Equal To - search
Period String - time
Greater StringThan Or Equal To - time
Less StringThan Or Equal To
Supporting Types
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding
- Index
Columns List<string> Columns of the index.
- Index
Hash stringValue Numerical representation of the index.
- Index
Name string Name of the index.
- Reference
Count int The number of the times the object is referenced within the SQL Tuning advisor task findings.
- Schema string
Schema of the object.
- Table
Name string Table's name related to the index.
- Index
Columns []string Columns of the index.
- Index
Hash stringValue Numerical representation of the index.
- Index
Name string Name of the index.
- Reference
Count int The number of the times the object is referenced within the SQL Tuning advisor task findings.
- Schema string
Schema of the object.
- Table
Name string Table's name related to the index.
- index
Columns List<String> Columns of the index.
- index
Hash StringValue Numerical representation of the index.
- index
Name String Name of the index.
- reference
Count Integer The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema String
Schema of the object.
- table
Name String Table's name related to the index.
- index
Columns string[] Columns of the index.
- index
Hash stringValue Numerical representation of the index.
- index
Name string Name of the index.
- reference
Count number The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema string
Schema of the object.
- table
Name string Table's name related to the index.
- index_
columns Sequence[str] Columns of the index.
- index_
hash_ strvalue Numerical representation of the index.
- index_
name str Name of the index.
- reference_
count int The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema str
Schema of the object.
- table_
name str Table's name related to the index.
- index
Columns List<String> Columns of the index.
- index
Hash StringValue Numerical representation of the index.
- index
Name String Name of the index.
- reference
Count Number The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema String
Schema of the object.
- table
Name String Table's name related to the index.
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding
- Object string
Name of the object.
- Object
Hash stringValue Numerical representation of the object.
- Object
Type string Type of the object.
- Problem
Type string Type of statistics problem related to the object.
- Reference
Count int The number of the times the object is referenced within the SQL Tuning advisor task findings.
- Schema string
Schema of the object.
- Object string
Name of the object.
- Object
Hash stringValue Numerical representation of the object.
- Object
Type string Type of the object.
- Problem
Type string Type of statistics problem related to the object.
- Reference
Count int The number of the times the object is referenced within the SQL Tuning advisor task findings.
- Schema string
Schema of the object.
- object String
Name of the object.
- object
Hash StringValue Numerical representation of the object.
- object
Type String Type of the object.
- problem
Type String Type of statistics problem related to the object.
- reference
Count Integer The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema String
Schema of the object.
- object string
Name of the object.
- object
Hash stringValue Numerical representation of the object.
- object
Type string Type of the object.
- problem
Type string Type of statistics problem related to the object.
- reference
Count number The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema string
Schema of the object.
- object str
Name of the object.
- object_
hash_ strvalue Numerical representation of the object.
- object_
type str Type of the object.
- problem_
type str Type of statistics problem related to the object.
- reference_
count int The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema str
Schema of the object.
- object String
Name of the object.
- object
Hash StringValue Numerical representation of the object.
- object
Type String Type of the object.
- problem
Type String Type of statistics problem related to the object.
- reference
Count Number The number of the times the object is referenced within the SQL Tuning advisor task findings.
- schema String
Schema of the object.
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic
- Finding
Benefits List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Benefit> The benefits of the findings in the SQL Tuning Advisor summary report.
- Finding
Counts List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Count> The number of findings in the SQL Tuning Advisor summary report.
- Statement
Counts List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Statement Count> The number of statements in the SQL Tuning Advisor summary report.
- Finding
Benefits []GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Benefit The benefits of the findings in the SQL Tuning Advisor summary report.
- Finding
Counts []GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Count The number of findings in the SQL Tuning Advisor summary report.
- Statement
Counts []GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Statement Count The number of statements in the SQL Tuning Advisor summary report.
- finding
Benefits List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Benefit> The benefits of the findings in the SQL Tuning Advisor summary report.
- finding
Counts List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Count> The number of findings in the SQL Tuning Advisor summary report.
- statement
Counts List<GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Statement Count> The number of statements in the SQL Tuning Advisor summary report.
- finding
Benefits GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Benefit[] The benefits of the findings in the SQL Tuning Advisor summary report.
- finding
Counts GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Count[] The number of findings in the SQL Tuning Advisor summary report.
- statement
Counts GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Statement Count[] The number of statements in the SQL Tuning Advisor summary report.
- finding_
benefits GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Benefit] The benefits of the findings in the SQL Tuning Advisor summary report.
- finding_
counts GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Finding Count] The number of findings in the SQL Tuning Advisor summary report.
- statement_
counts GetManaged Database Sql Tuning Advisor Tasks Summary Report Statistic Statement Count] The number of statements in the SQL Tuning Advisor summary report.
- finding
Benefits List<Property Map> The benefits of the findings in the SQL Tuning Advisor summary report.
- finding
Counts List<Property Map> The number of findings in the SQL Tuning Advisor summary report.
- statement
Counts List<Property Map> The number of statements in the SQL Tuning Advisor summary report.
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit
- Db
Time intAfter Implemented The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
- Db
Time intAfter Recommended The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
- Db
Time intBefore Implemented The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
- Db
Time intBefore Recommended The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
- Db
Time intAfter Implemented The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
- Db
Time intAfter Recommended The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
- Db
Time intBefore Implemented The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
- Db
Time intBefore Recommended The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
- db
Time IntegerAfter Implemented The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
- db
Time IntegerAfter Recommended The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
- db
Time IntegerBefore Implemented The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
- db
Time IntegerBefore Recommended The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
- db
Time numberAfter Implemented The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
- db
Time numberAfter Recommended The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
- db
Time numberBefore Implemented The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
- db
Time numberBefore Recommended The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
- db_
time_ intafter_ implemented The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
- db_
time_ intafter_ recommended The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
- db_
time_ intbefore_ implemented The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
- db_
time_ intbefore_ recommended The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
- db
Time NumberAfter Implemented The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
- db
Time NumberAfter Recommended The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
- db
Time NumberBefore Implemented The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
- db
Time NumberBefore Recommended The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount
- Alternate
Plan int The number of distinct SQL statements with alternative plan recommendations.
- Implemented
Sql intProfile The number of distinct SQL statements with implemented SQL profiles.
- Index int
The number of distinct SQL statements with index recommendations.
- Recommended
Sql intProfile The number of distinct SQL statements with recommended SQL profiles.
- Restructure int
The number of distinct SQL statements with restructured SQL recommendations.
- Statistics int
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- Alternate
Plan int The number of distinct SQL statements with alternative plan recommendations.
- Implemented
Sql intProfile The number of distinct SQL statements with implemented SQL profiles.
- Index int
The number of distinct SQL statements with index recommendations.
- Recommended
Sql intProfile The number of distinct SQL statements with recommended SQL profiles.
- Restructure int
The number of distinct SQL statements with restructured SQL recommendations.
- Statistics int
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- alternate
Plan Integer The number of distinct SQL statements with alternative plan recommendations.
- implemented
Sql IntegerProfile The number of distinct SQL statements with implemented SQL profiles.
- index Integer
The number of distinct SQL statements with index recommendations.
- recommended
Sql IntegerProfile The number of distinct SQL statements with recommended SQL profiles.
- restructure Integer
The number of distinct SQL statements with restructured SQL recommendations.
- statistics Integer
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- alternate
Plan number The number of distinct SQL statements with alternative plan recommendations.
- implemented
Sql numberProfile The number of distinct SQL statements with implemented SQL profiles.
- index number
The number of distinct SQL statements with index recommendations.
- recommended
Sql numberProfile The number of distinct SQL statements with recommended SQL profiles.
- restructure number
The number of distinct SQL statements with restructured SQL recommendations.
- statistics number
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- alternate_
plan int The number of distinct SQL statements with alternative plan recommendations.
- implemented_
sql_ intprofile The number of distinct SQL statements with implemented SQL profiles.
- index int
The number of distinct SQL statements with index recommendations.
- recommended_
sql_ intprofile The number of distinct SQL statements with recommended SQL profiles.
- restructure int
The number of distinct SQL statements with restructured SQL recommendations.
- statistics int
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
- alternate
Plan Number The number of distinct SQL statements with alternative plan recommendations.
- implemented
Sql NumberProfile The number of distinct SQL statements with implemented SQL profiles.
- index Number
The number of distinct SQL statements with index recommendations.
- recommended
Sql NumberProfile The number of distinct SQL statements with recommended SQL profiles.
- restructure Number
The number of distinct SQL statements with restructured SQL recommendations.
- statistics Number
The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount
- Distinct
Sql int The number of distinct SQL statements.
- Error
Count int The number of distinct SQL statements with errors.
- Finding
Count int The number of distinct SQL statements with findings.
- Total
Sql int The total number of SQL statements.
- Distinct
Sql int The number of distinct SQL statements.
- Error
Count int The number of distinct SQL statements with errors.
- Finding
Count int The number of distinct SQL statements with findings.
- Total
Sql int The total number of SQL statements.
- distinct
Sql Integer The number of distinct SQL statements.
- error
Count Integer The number of distinct SQL statements with errors.
- finding
Count Integer The number of distinct SQL statements with findings.
- total
Sql Integer The total number of SQL statements.
- distinct
Sql number The number of distinct SQL statements.
- error
Count number The number of distinct SQL statements with errors.
- finding
Count number The number of distinct SQL statements with findings.
- total
Sql number The total number of SQL statements.
- distinct_
sql int The number of distinct SQL statements.
- error_
count int The number of distinct SQL statements with errors.
- finding_
count int The number of distinct SQL statements with findings.
- total_
sql int The total number of SQL statements.
- distinct
Sql Number The number of distinct SQL statements.
- error
Count Number The number of distinct SQL statements with errors.
- finding
Count Number The number of distinct SQL statements with findings.
- total
Sql Number The total number of SQL statements.
GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo
- Description string
The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- Id string
The ID of the SQL Tuning Advisor task. This is not the OCID.
- Name string
The name of the SQL Tuning Advisor task.
- Owner string
The owner of the SQL Tuning Advisor task.
- Running
Time int The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
- Status string
The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- Time
Ended string The end time of the task execution.
- Time
Started string The start time of the task execution.
- Description string
The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- Id string
The ID of the SQL Tuning Advisor task. This is not the OCID.
- Name string
The name of the SQL Tuning Advisor task.
- Owner string
The owner of the SQL Tuning Advisor task.
- Running
Time int The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
- Status string
The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- Time
Ended string The end time of the task execution.
- Time
Started string The start time of the task execution.
- description String
The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- id String
The ID of the SQL Tuning Advisor task. This is not the OCID.
- name String
The name of the SQL Tuning Advisor task.
- owner String
The owner of the SQL Tuning Advisor task.
- running
Time Integer The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
- status String
The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- time
Ended String The end time of the task execution.
- time
Started String The start time of the task execution.
- description string
The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- id string
The ID of the SQL Tuning Advisor task. This is not the OCID.
- name string
The name of the SQL Tuning Advisor task.
- owner string
The owner of the SQL Tuning Advisor task.
- running
Time number The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
- status string
The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- time
Ended string The end time of the task execution.
- time
Started string The start time of the task execution.
- description str
The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- id str
The ID of the SQL Tuning Advisor task. This is not the OCID.
- name str
The name of the SQL Tuning Advisor task.
- owner str
The owner of the SQL Tuning Advisor task.
- running_
time int The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
- status str
The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- time_
ended str The end time of the task execution.
- time_
started str The start time of the task execution.
- description String
The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- id String
The ID of the SQL Tuning Advisor task. This is not the OCID.
- name String
The name of the SQL Tuning Advisor task.
- owner String
The owner of the SQL Tuning Advisor task.
- running
Time Number The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
- status String
The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
- time
Ended String The end time of the task execution.
- time
Started String The start time of the task execution.
Package Details
- Repository
- https://github.com/pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.