How To Get Explain Plan for SQL Statements for Oracle Lite Client
(Doc ID 761917.1)
Last updated on JULY 14, 2020
Applies to:Oracle Mobile Field Service - Version 11.5.10 to 12.1.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
This document provides the steps to create an execution plan or explain plan for statements issued on the client side of Mobile Field Service - in Oracle Lite. This can be used as a tool to investigate performance issues.
This document assumes that the sql statement to be analyzed is already identified. If necessary, <Note 761918.1> can help in identifying the statement.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document