Fetch the details of Sql statements in the Sql tuning set.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningSets/:sqlTuningSetId
Fetch the details of Sql statements in the Sql tuning set specified by name, owner and optional filter parameters.
Request Body
{"owner"=>"<string>", "name"=>"<string>", "basicFilter"=>"null", "credentialDetails"=>{"sqlTuningSetAdminCredentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"SECRET"}, "rankingMeasure1"=>"null", "rankingMeasure2"=>"null", "rankingMeasure3"=>"null", "recursiveSql"=>"HAS_RECURSIVE_SQL", "resultLimit"=>0, "resultPercentage"=>1}
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"}