Enables automatic initial plan capture.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/enableAutomaticInitialPlanCapture
Enables automatic initial plan capture. When enabled, the database checks whether executed SQL statements are eligible for automatic capture. It creates initial plan baselines for eligible statements.
By default, the database creates a SQL plan baseline for every eligible repeatable statement, including all recursive SQL and monitoring SQL. Thus, automatic capture may result in the creation of an extremely large number of plan baselines. To limit the statements that are eligible for plan baselines, configure filters.
Request Body
{"credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"SECRET"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
""