Date: Fri, 13 Jun 2008 09:37:40 -0700 (PDT)
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;Received on Fri Jun 13 2008 - 11:37:40 CDT