Re: Views

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 Received on Fri Jun 13 2008 - 14:35:07 CDT