Re: SQL ADVISOR schema structure
Date: Wed, 17 Feb 2010 14:04:06 -0800
> Would someone please send me the intermediate table(s) and the join
> predicates to be able to join USER_ADVISOR_SQLA_WK_STMTS to
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-lReceived on Wed Feb 17 2010 - 16:04:06 CST