Creates an empty Sql tuning set.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningSets
Creates an empty Sql tuning set within the Managed Database specified by managedDatabaseId.
Request Body
{"name"=>"<string>", "credentialDetails"=>{"sqlTuningSetAdminCredentialType"=>"SECRET", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"NAMED_CREDENTIAL"}, "description"=>"<string>", "owner"=>"null", "showSqlOnly"=>0}
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
{"owner":"\u003cstring\u003e","name":"\u003cstring\u003e","allSqlStatementsFetched":"YES","description":"\u003cstring\u003e","errorMessage":"\u003cstring\u003e","id":"\u003cinteger\u003e","scheduledJobName":"\u003cstring\u003e","sqlList":[{"sqlId":"\u003cstring\u003e","planHashValue":"\u003clong\u003e","containerDatabaseId":"\u003clong\u003e","metrics":[{"bufferGets":"\u003clong\u003e","cpuTime":"\u003clong\u003e","directWrites":"\u003clong\u003e","diskReads":"\u003clong\u003e","elapsedTime":"\u003clong\u003e","executions":"\u003clong\u003e"},{"bufferGets":"\u003clong\u003e","cpuTime":"\u003clong\u003e","directWrites":"\u003clong\u003e","diskReads":"\u003clong\u003e","elapsedTime":"\u003clong\u003e","executions":"\u003clong\u003e"}],"module":"\u003cstring\u003e","schema":"\u003cstring\u003e","sqlText":"\u003cstring\u003e"},{"sqlId":"\u003cstring\u003e","planHashValue":"\u003clong\u003e","containerDatabaseId":"\u003clong\u003e","metrics":[{"bufferGets":"\u003clong\u003e","cpuTime":"\u003clong\u003e","directWrites":"\u003clong\u003e","diskReads":"\u003clong\u003e","elapsedTime":"\u003clong\u003e","executions":"\u003clong\u003e"},{"bufferGets":"\u003clong\u003e","cpuTime":"\u003clong\u003e","directWrites":"\u003clong\u003e","diskReads":"\u003clong\u003e","elapsedTime":"\u003clong\u003e","executions":"\u003clong\u003e"}],"module":"\u003cstring\u003e","schema":"\u003cstring\u003e","sqlText":"\u003cstring\u003e"}],"statementCount":"\u003cinteger\u003e","status":"CHAIN_STALLED","timeCreated":"\u003cdateTime\u003e","timeLastModified":"\u003cdateTime\u003e"}