Toad World® Forums

Toad for Oracle 14 / sql optimizer 9.3.3

HI

I have a Oracle database 12.1.0.2 , without tuning and diagnostics packs that I have disabled.

I've always managed this DB with toad by disabling all OEM options. But I've purchased recently SQL Optimizer. Quest certified me that this tool didn't use any forbidden options as T&D Packs.

But It seems by reading user guide for 9.2.2 that to optimize index or analyze impact, this tool requires:

after this doc:

Requires access to the following system views:

SYS.DBA_HIST_SNAPSHOT

SYS.DBA_HIST_SQLTEXT

SYS.DBA_HIST_SQLSTAT
Display the control information for the Workload Repository

Requires access to the following system view:

SYS. DBA_HIST_WR_CONTROL
Display the SQL summary for the Workload Repository

Requires access to the following system view:

SYS. DBA_HIST_SQL_SUMMARY

What is TRUE?

Regards