Jump to

• Request
• Response

Get execution plan for an SQL Statement

get

/database/performance/sql_statements/{sql_id}/plan

Returns all GV$SQL_PLAN records for a specified SQL_ID. A client requires SQL Administrator role to invoke this service.

Request

Path Parameters

• sql_id:
  SQL identifier.

Query Parameters

• limit(optional):
  The maximum number of records to return.
• q(optional):
  Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.

Back to Top

Response

200 Response

Execution plan for the specified SQL statement.

Back to Top