Re: Views

On Jun 17, 3:30 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> "Mtek" <m..._at_mtekusa.com> schreef in berichtnews:e0615271-0363-4abf-89cf-5b67cb8946a2_at_m3g2000hsc.googlegroups.com...
>
>
>
> > On Jun 13, 2:35 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> >> On Jun 13, 11:37 am, Mtek <m..._at_mtekusa.com> wrote:
>
> >> > On Jun 13, 11:25 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> >> > > On Jun 13, 9:46 am, Mtek <m..._at_mtekusa.com> wrote:
>
> >> > > > Hi,
>
> >> > > > We use TOAD as our GUI to see the database. I put in a query that
> >> > > > selects from V$SQL, but I get a missing expression. The same query
> >> > > > works from within SQLPLUS. Even it I change it to V_$SQL, no
> >> > > > good.
>
> >> > > > Is there something special with these dictionary tables???
>
> >> > > > Thanks!
>
> >> > > > John
>
> >> > > Without seeing your query no one can answer that.
>
> >> > > Post it.
>
> >> > > David Fitzjarrell
>
> >> > select a.USERNAME,
> >> > DISK_READS,
> >> > EXECUTIONS,
> >> > round(DISK_READS / decode(EXECUTIONS, 0, 1, EXECUTIONS))
> >> > "Reads/
> >> > Execs",
> >> > SQL_TEXT
> >> > from dba_users a, v$session, v$sqlarea
> >> > where PARSING_USER_ID=USER_ID
> >> > and ADDRESS=SQL_ADDRESS(+)
> >> > and DISK_READS > 10000
> >> > order by DISK_READS desc, EXECUTIONS desc;- Hide quoted text -
>
> >> > - Show quoted text -
>
> >> Now post the exact error displayed.
>
> >> David Fitzjarrell
>
> > A query like this give a "Missing Expression" from TOAD, but works
> > fine from SQLPLUS:
>
> > select EXECUTIONS,
> > BUFFER_GETS,
> > round(DISK_READS / decode(EXECUTIONS, 0, 1, EXECUTIONS) / 400,2)
> > "Gets/Execs",
> > SQL_TEXT
> > from sys.v_$sqlarea
> > where BUFFER_GETS / decode(EXECUTIONS,0,1, EXECUTIONS) / 400 > 10
> > order by EXECUTIONS desc;
>
> > John
>
> Try to replace "Gets/Execs" with get_execs (no '/', no quotes)
> Looks like a TOAD problem. PL/SQL Developer runs this query just fine.
>
> Shakespeare

You're smart guy......thanks a bunch!!! Received on Tue Jun 17 2008 - 07:40:08 CDT