Oracle Sql Tuning API is one of 378 APIs that Oracle publishes on the APIs.io network, described by a machine-readable OpenAPI specification.
The published artifact set on APIs.io includes an OpenAPI specification and an API reference.
This API exposes
17 operations
across 16 paths,
and defines 41 schemas.
It is described by OpenAPI 3.2.0, at version 20201101.
Requests are made against 2 base URLs: http://dbmgmt.{region}.oci.oraclecloud.com/20201101, https://dbmgmt.{region}.oci.oraclecloud.com/20201101.
The identity and technical contract details declared by the specification.
SqlTuningSetSummary
object
The summary information of a SQL tuning set.
10 properties
2 required
SqlTuningTaskSqlExecutionPlanStep
object
A step in the SQL execution plan.
29 properties
SqlTuningSet
object
Details of the Sql tuning set.
12 properties
2 required
DropSqlTuningTaskDetails
object
The request to drop a SQL tuning task. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
3 properties
1 required
SqlTuningTaskCredentialDetails
object
The credential used to connect to the database.
3 properties
3 required
SqlTuningAdvisorTaskCollection
object
The SQL Tuning Advisor task list.
1 property
1 required
DropSqlTuningSetDetails
object
The details required to drop a Sql tuning set. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
5 properties
1 required
LoadSqlTuningSetDetails
object
The details required to load the Sql statements into the Sql tuning set. It takes either credentialDetails or databaseCredential. It's recommended to provide d…
27 properties
2 required
StartSqlTuningTaskDetails
object
The request to start a SQL tuning task. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
11 properties
3 required
SqlTuningAdvisorTaskRecommendationCollection
object
The SQL Tuning Advisor recommendations for a given SQL statement.
1 property
1 required
SqlTuningTaskReturn
object
The returned object for starting or cloning a SQL tuning advisor task.
1 property
1 required
ValidateBasicFilterDetails
object
Validate the basic filter criteria provided by the user. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
5 properties
3 required
CreateSqlTuningSetDetails
object
Create an empty Sql tuning sets. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
6 properties
1 required
SqlTuningAdvisorTaskSqlExecutionPlan
object
A SQL execution plan.
1 property
1 required
SqlTuningAdvisorTaskSummaryFindingBenefits
object
The benefits of the findings in the SQL Tuning Advisor summary report.
4 properties
4 required
SqlTuningAdvisorTaskSummaryReportStatementCounts
object
The number of statements in the SQL Tuning Advisor summary report.
4 properties
4 required
DatabaseCredentialDetails
object
The credential to connect to the database to perform tablespace administration tasks.
1 property
1 required
SaveSqlTuningSetAsDetails
object
Save current list of Sql statements into another Sql tuning set. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseC…
24 properties
3 required
SqlTuningAdvisorTaskSummaryReportIndexFindingSummary
object
A summary for all the index findings in a SQL Tuning Advisor task. Includes the index's hash value, table name, schema, index name, reference count and index c…
6 properties
6 required
SqlTuningAdvisorTaskSummaryReportTaskInfo
object
The general information regarding the SQL Tuning Advisor task.
8 properties
5 required
SqlTuningAdvisorTaskSummaryReport
object
The content of the SQL Tuning Advisor summary report.
4 properties
2 required
SqlTuningAdvisorTaskFindingSummary
object
A summary of the findings of the objects in a tuning task that match a given filter. This includes the kind of findings that were reported, whether the benefit…
17 properties
6 required
SqlTuningSetInput
object
The SQL tuning set for a SQL tuning task.
2 properties
2 required
SqlTuningAdvisorTaskSummaryFindingCounts
object
The number of findings in the SQL Tuning Advisor summary report.
6 properties
6 required
SqlTuningSetCollection
object
The details in the SQL tuning set summary.
2 properties
2 required
SqlInSqlTuningSet
object
Sql information in the Sql tuning set.
7 properties
2 required
CloneSqlTuningTaskDetails
object
The request to clone and run a SQL tuning task. The new task uses the same inputs as the one being cloned. It takes either credentialDetails or databaseCredent…
5 properties
2 required
SqlTuningAdvisorTaskSummary
object
The summary of a SQL Tuning Advisor task.
12 properties
1 required
SqlTuningSetAdminCredentialDetails
object
The credential to connect to the database to perform Sql tuning set administration tasks.
3 properties
3 required
SqlTuningAdvisorTaskFindingCollection
object
The list of findings for a SQL Tuning Advisor task.
1 property
1 required
SqlTuningTaskPlanStats
object
The statistics of a SQL execution plan.
3 properties
3 required
SqlTuningSetAdminActionStatus
object
The status of a Sql tuning set admin action.
6 properties
1 required
SqlTuningAdvisorTaskSummaryReportStatistics
object
The statistics of the statements and findings in the SQL Tuning Advisor summary report.
3 properties
3 required
SqlTuningTaskSqlDetail
object
The details of the SQL statements on which SQL tuning is performed.
1 property
1 required
SqlTuningAdvisorTaskSummaryReportObjectStatFindingSummary
object
A summary for all the statistic findings of an object in a SQL Tuning Advisor task. Includes the object's hash, name, type, schema, problem type and the object…
6 properties
6 required
SqlMetrics
object
Metrics of the Sql in the Sql tuning set.
6 properties
DropSqlsInSqlTuningSetDetails
object
Drops the selected list of Sql statements from the current Sql tuning set. The basicFilter parameter specifies the Sql predicate to filter the Sql from the Sql…
6 properties
1 required
Error
object
Error Information.
2 properties
2 required
SqlTuningAdvisorTaskRecommendationSummary
object
A recommendation for a given object in a SQL Tuning Task.
10 properties
4 required
FetchSqlTuningSetDetails
object
The details required to fetch the Sql tuning set details. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredenti…
11 properties
2 required
ExecutionPlanStatsComparision
object
The comparison report of the SQL execution plan statistics in the original and modified plan.
2 properties
2 required
The full machine-readable OpenAPI contract behind this narrative.
Other APIs Oracle publishes across the network.
