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