My Oracle Support Banner

How To Get Explain Plan for SQL Statements for Oracle Lite Client (Doc ID 761917.1)

Last updated on JUNE 13, 2019

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.

Goal

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.

Solution

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
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.