Return
-
Title
Session Browser provide schema owner in Explain Plan -
Description
Please modify the Session Browser Explain Plan function so that it automatically provides the schema owner for each table/view referenced in the SQL and then generates the Explain Plan.
Reason:
We want to be able to run an Explain Plan with a privileged account, not as the non-privileged session USERNAME account. We get ORA-942 Table or view does not exist error now in the Explain Plan window because applications use private synonyms.Without this modification, for us, the effectiveness of the Session Browser Explain Plan feature is very limited. -
Resolution
WORKAROUND:
None
STATUS:
An Enhancement request has been submitted for future release.
-
Defect ID
ST11677