Re: dbms_xplan.display_cursor question

From: (wrong string) 조동욱 <ukja.dion_at_gmail.com>
Date: Fri, 27 Feb 2009 09:11:20 +0900
Message-ID: <43c2e3d60902261611g5ea64327meea7e368097778a0_at_mail.gmail.com>

dbms_xplan.displa_cursor is available from 10gR1, but "ALLSTATS LAST" option is from 10gR2.

In 10gR1, you can use RUNSTATS_LAST options.

---

Dion Cho - Oracle Performance Storyteller

http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)

---

On Thu, Feb 26, 2009 at 11:42 PM, jaromir nemec <jaromir_at_db-nemec.com>wrote:

> Hi GBA,
>
> If I can recall it correctly the problem is in using 'select * ...'.
> Try instead explicit reference of the column:
>
> SELECT PLAN_TABLE_OUTPUT FROM table(DBMS_XPLAN.DISPLAY('plan_table',
> 'N1','ALL'));
>
> Yes, and searching Oracle documentation suggests that the display_cursor
> function is available in 10g Release 2.
>
> HTH
>
> Jaromir
>
> > Hi list,
> >
> > I'm trying to run select * from
> > table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST')); in
> > SQL*PLUS (Oracle EE 10.1.0.5.0 64 bit) but i'm getting this error:
> >
> > select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS
> > LAST'))
> > *
> > ERROR at line 1:
> > ORA-22905: cannot access rows from a non-nested table item
> >
> > Is it a feature available in 10g R2 and onwards only?
> >
> > --
> > Regards
> > GBA
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 26 2009 - 18:11:20 CST