Load Sql statements into a Sql tuning set.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningSets/:sqlTuningSetId/actions/loadSqlTuningSet
Load Sql statements into the Sql tuning set specified by name and optional filter parameters within the Managed Database specified by managedDatabaseId.
Request Body
{"name"=>"<string>", "loadType"=>"INCREMENTAL_CURSOR_CACHE", "attributeList"=>"TYPICAL", "baselineName"=>"null", "basicFilter"=>"null", "beginSnapshot"=>1, "captureMode"=>"MODE_REPLACE_OLD_STATS", "captureOption"=>"MERGE", "commitRows"=>0, "credentialDetails"=>{"sqlTuningSetAdminCredentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"SECRET"}, "endSnapshot"=>2, "isIgnoreNull"=>true, "loadOption"=>"INSERT", "owner"=>"null", "rankingMeasure1"=>"null", "rankingMeasure2"=>"null", "rankingMeasure3"=>"null", "recursiveSql"=>"HAS_RECURSIVE_SQL", "repeatInterval"=>300, "resultLimit"=>0, "resultPercentage"=>1, "showSqlOnly"=>0, "totalTimeLimit"=>1800, "updateAttributes"=>nil, "updateCondition"=>nil, "updateOption"=>"REPLACE"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A token that uniquely identifies a request so it can be retried in case of a timeout or | |
server error without risk of executing that same action again. Retry tokens expire after 24 | |||
hours, but can be invalidated before then due to conflicting operations. For example, if a resource | |||
has been deleted and purged from the system, then a retry of the original creation request | |||
might be rejected. | |||
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"status":"SUCCEEDED","errorCode":"\u003cinteger\u003e","errorMessage":"\u003cstring\u003e","showSqlOnly":"\u003cinteger\u003e","sqlStatement":"\u003cstring\u003e","successMessage":"\u003cstring\u003e"}