Auto-optimize in Session Browser does not run as the schema owner of the 'current statement' (4308978)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Auto-optimize in Session Browser does not run as the schema owner of the 'current statement'
Description

In Session Browser, it's possible to launch auto-optimize from the 'Current Statement', to optimize the current statement. However, the auto-optimize is not actually run against the session associated with the actual session details.
Resolution

WORKAROUND
Click on the dropdown arrow next to optimize button and select 'Advanced Optimization...'
SQL Optimizer for Oracle will launch and the schema to run the sql statement against, can be changed there.
STATUS
Fixed in version 13.0. The latest release can be downloaded here.
Defect ID

TOR-2272

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title