Re: SQL ADVISOR schema structure

Hi Rich,

> Would someone please send me the intermediate table(s) and the join
> predicates to be able to join USER_ADVISOR_SQLA_WK_STMTS to
> USER_ADVISOR_ACTIONS?

Did you trace the DBMS_SQLTUNE.REPORT_TUNING_TASK call with a 10046
level 4? That might provide some clues.

> Better yet, is there an ER diagram for the ADVISOR or any online
> documentation other than Oracle docs?

Not that I know of!

-- 
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l

Other related posts: